/> 
IdentityTechnical 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).
