SAS and SPSS are leading in Analytic market. In mainframe we use SAS for different report generation purpose. Learning SAS is the same whether you are in Windows environment or mainframe.
The following are SAS course details:
Module 1 – Base SAS | Hours | |
Data Structures
|
Introduction to SAS interface and library structure and definition |
4
|
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 |
10
|
Appending and Merging datasets | ||
SAS Functions for data manipulation | ||
Loops and Arrays in SAS | ||
Report Generation
|
Basic Proc steps – like Proc Contents |
10
|
Proc Format, Proc Report and Proc Tabulate | ||
Proc steps for basic statistics – like Proc Univariate and Proc Means |
Module 2 – Advanced SAS | Hours | |
Proc SQL
|
Introduction to SQL – basic DBMS and RDBMS concepts |
8
|
Using SQL Procedures in SAS | ||
Using conditional statements in SQL and aggregate functions | ||
Data manipulation using Proc SQL | ||
SAS Macros
|
Introduction to Macros |
6
|
Local and Global declarations | ||
Using built-in macro procedures and functions |
You must be logged in to post a comment.