SAS TRAINING ON BASE AND ADVANCED

SAS MODULE DESGIN



MODULE 1 – BASE SAS 

1. Data Structures :

• Introduction to SAS Interface, Library structure and Definition
• Reading Data using Datalines , Impoting and Exporting Datasets
• Infiles statement – reading raw Data
• Formats and Informats
• Variable attributes and Data modification using Data and Set statements

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

3 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

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

2. SAS Macros

• Introduction to Macros
• Local and Global declarations
• Using buit – in Macro procedures and Functions