Technical Knowledge â?¢ Experience includes using Base Procedures, Graph, Macros, Data Step, and SQL, use of formats and informat and Proc Format. â?¢ Experienced in using SAS function, in-file statements, ODS, Visualization. â?¢ Good exposure in SAS data step programming, including merging and reading external data files and Exporting. â?¢ Good basic knowledge of Excel â?¢ Experience in SQL (DML & DDL) & Proc SQL in SAS. Summery â?¢ SAS- Statistical Analytics System â?¢ Base Procedures- Proc means, Proc corr, Proc reg, Proc format, Proc freq, Proc contents etc. have good knowledge to create the report on statistical summery. Visualization- Define the data through graphs and plot the different graphs to show the dataset as per requirement in SAS. INFILE- Bring the data from different sources like SQL, EXCEL and also obtain the system files in SAS by using Infile statement. ODS (Output Delivery Services) - Convert the data in PDF file, RTF file, HTML file for reporting by using ODS Statement in SAS. USER DEFINED FUNCTION- Create Macros, Format & Informat, Loop & array in SAS. CONDITIONAL PROGRAMMING- Using of IF & ELSE, WHERE and using some Arithmetic and Logical operators in SAS. â?¢ SQL- Structure query language (DML & DDL) which are used to modify the data. DML- The SQL statements in the DML class are SELECT, INSERT, UPDATE and DELETE. DDL- DDL is used to define the data base structure. Example- CREATE, DROP, ALTER. INTRODUCTION TO SQL- Terminology, Syntax, Statements (Create, Select, From, Where, Group by, Having, Order by etc.) (Feedback, Calculated, count, keep, drop etc.) Conditional Operators (Contains, Between and, case & when, Like etc.) Set Operators (Union, Union all, Intersect, except) SQL Joins (Simple Join, Inner Join, Full join, Outer Joins- Left outer join & Right outer join, Cross Join).