|
SAS
|
|
UNIT 1 |
|
|
|
Introduction
|
|
|
|
SAS STATEMENT SYNTAX |
|
|
|
SAS DATASTEP BOUNDARY
READING EXTERNAL DATA
- List Input
- Column input
- Formated Input
|
|
|
|
SAS DATA STEP PROGRAMMING |
|
|
|
- Variable Definitions
- Numeric & Character Manipulation
- Functions
- Formats and Informats
- Label
- Import and Export
- Condition and Loops
- Arrays
- Retain
- First.byvarname & Last.byvarname
- Combining SAS Data Sets
- Data Step Interface
- File Direction
|
|
|
|
SAS PROCEDURES |
|
|
|
- Proc Contents
- Proc Print
- Proc Freq
- Proc Summary
- Proc Means
- Proc Univariate
- Proc Transpose
- Proc Compare
- Proc Datasets
- Proc Chart
- Proc Plot
|
|
|
|
SAS PROC SQL
|
|
|
|
- SELECT
- FROM
- WHERE
- GROUP BY
- HAVING
- ORDER BY
- Functions
- Subqueries
- Inner Joins
- Outer Joins
- Full Joins
- Set Operators
- Union
- SQL View
- Compare of SQL Join with Datastep Merge
|
|
|
|
REPORT GENERATION |
|
|
|
- Proc Tabulate
- Proc Report
- Data_NUL_and PUT
- Basics of SAS Output Delivery System
- SAS/ GRAPH, SAS/ STAT
SAS MACROS
- Introduction to SAA Macros
|