Navin Kohli

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