OBJECTIVES: This course is designed for new SAS users to develop skills as a SAS programmer / data analyst position.
TOPICS: This course will cover SAS fundamental concepts and rules, importing external files, accessing data, creating data structures, exporting data to Excel, etc., SAS expressions and functions, managing data, data cleaning techniques, preparing a SAS dataset for statistical analysis, etc..
GOAL: Upon the completion of this course, you will be able to independently write and debug SAS programs, successfully pass SAS Base Programming certification exam, and carry out primary data analysis in real world projects.
1. Introduction to SAS components and concepts
Overview of the SAS System
What can SAS do?
SAS Display Manager System
Basic structure of SAS
Preliminary concepts and rules
SAS Data libraries reference and SAS resources
2. Accessing Data and Creating Data Structures
Reading raw data files using INFILE and INPUT statement
Reading external file
Assigning and change variable attributes
Import database table or data file into SAS dataset
Reading existing SAS dataset
Restricting observations while reading data
Creating temporary and permanent SAS data sets
Exporting data to different files
Displaying contents of dataset
Restricting observations and variables in a SAS data set processed
3. SAS Expression and Functions
Conditional expression (WHERE and IF)
SAS functions: mathematical and statistical
Numeric functions & character functions
4. Managing Data
Conditionally IF-THN-ELSE execute SAS statements
Sort observations in a SAS data set
KEEP, DROP, DELETE, RENAME and OUTPUT statements
PROC FORMAT statement
Process data using SAS DO-LOOPS
Process data usin