Introduction
  • What are you going to learn from this course
SAS environment and basic concepts
  • Introduce SAS environment
  • SAS library
  • Try SAS codes
  • Home work and data installation
  • SAS Cloud Version
  • Introduction to SAS Studio Installation on University Edition
Get started SAS programming
  • Create data sets from external files
  • SAS program - create data sets
  • Valid names and comments
  • SAS program -- Valid names and comments
  • Data type and format
  • SAS program -- data type and format
  • SAS program - date and format
  • Mechanism of SAS data set
  • Summarize SAS operations
Input and output raw data
  • List input (1)
  • List input (2)
  • SAS program -- list input
  • Read data with fixed layout
  • Read data with modified list input
  • Input data with other features
  • Write data using data step
  • SAS program --write data
  • Import and export data
Manipulate data by data step programming
  • Duplicate data sets
  • SAS program -- duplicate data sets
  • Modify variables
  • SAS program -- modify variables
  • Variables selection.
  • Rename variables
  • SAS program -- rename variables
  • Assign labels to variables
  • SAS program -- assign labels to variables
  • Subsetting data sets
  • SAS program -- Subsetting data sets
Control flow in SAS
  • Structured programming (I)
  • SAS program -- Structured programming (I)
  • Structured programming (II)
  • SAS program -- Structured programming (II)
SAS data step functions
  • Data step character functions
  • SAS program --data step character functions
  • Data step numeric functions
  • SAS program -- numeric functions
  • Data step special functions
  • Data step special functions
  • User defined format
  • SAS program -- User defined format
Use cases study (1)
  • Case study 001(read employee data)
  • SAS program -- read employee data
  • Case study 002(read chronic disease data)
  • SAS program -- Case study 002(read chronic disease data)
  • Case study 003 ( read business account data)
  • SAS program -- Case study 003 ( read business account data)
  • Case study 004 (process stock data)
  • SAS program -- Case study 004 (process stock data)
Other SAS features in data step programming
  • Automatic Variables(_N_ and _ERROR_)
  • Output statement
  • Return statement
  • pinpoint the first and last record
  • SAS program -- Pinpoint the first and last record
  • Retain statement
  • SAS program -- Retain statement
  • Data step array (1)
  • Data step array (2)
Use cases study (2)
  • Case study 005(create new KPI features)
  • Case study 006(students grades)
Browse, sort and combine data
  • Browse and print data set
  • SAS program -- Browse and print data set
  • Sort data
  • SAS program -- sort data
  • Merge multiple data sets
  • Stack data sets
  • Examples of merging and splitting data sets
Data processing and analysis
  • Transpose data sets
  • Examples of transposing data
  • Understand statistics and distribution..
  • Summarize continuous data
  • Examples of PROC MEANS (1)
  • Examples of PROC MEANS (2)
  • Examples of PROC MEANS (3)
  • Summarize categorical variables
  • Examples of PROC FREQ (1)
  • Examples of PROC FREQ (2)
  • Examples of PROC FREQ (3)
  • Understand uni-variate study
  • Examples of uni-variate analysis
  • Ranking data and bucket analysis