Module 1 - Base SAS | |
Data Structures |
Introduction to SAS interface and library structure and definition |
Reading data using Datalines and importing and exporting datasets | |
Infiles statement - reading raw data | |
Formats and Informats | |
Variable attributes and data modification using Data and Set statements | |
Data Management |
Using conditional statements to modify data - Where, If and Nested IF |
Appending and Merging datasets | |
SAS Functions for data manipulation | |
Loops and Arrays in SAS | |
Report Generation |
Basic Proc steps - like Proc Contents |
Proc Format, Proc Report and Proc Tabulate | |
Proc steps for basic statistics - like Proc Univariate and Proc Means |
Module 2 - Advanced SAS | |
Proc SQL |
Introduction to SQL - basic DBMS and RDBMS concepts |
Using SQL Procedures in SAS | |
Using conditional statements in SQL and aggregate functions | |
Data manipulation using Proc SQL | |
SAS Macros |
Introduction to Macros |
Local and Global declarations | |
Using built-in macro procedures and functions |