Skip to content
Introduction to Base SAS
- Module 1: Introduction to SAS Programmes
SAS System
SAS Syntax
SAS Programming Process
Rules within SAS programming
- Module 2: Introduction to SAS Programmes
SAS Libraries:
Permanent SAS Files
Temporary SAS Files
FILENAME & LIBNAME Statements
- Module 3: Accessing External & Reading Raw Data files into SAS using DATA STEP
Types of data SAS can read
Reading raw data file into SAS not in standard format
Reading external data into SAS
Reading Spreadsheet
Reading text file
Getting external data into SAS (Infile, Input, Proc)
- Module 4: How to Import Data from SQL SERVER into SAS
How to map/link SAS to SQL server (2008,2012,2014) etc
How to import data into SAS from SQL server
Reading Database Table file
How to convert the SQL server data into a SAS File
- Module 5: Formatting Data Values
Variables Attributes
Understanding Numeric Expressions and Assignment Statements
Missing Values
Character Variables
Numeric Variables
Date variables
Currency Variables
- Module 6: Modifying and Combining SAS Data Sets
Modifying a Dataset using the SET statement
Using Data statement to Stack multiple data sets
Using Data statement to Merge multiple data set
- Module 7: Manipulating and Transforming Data
Informants and Formats
Data Set Option (Drop, Keep, Firstobs, Obs)
PROC STEP
- Module 8: Producing Detailed and Summary Reports
Using PROC means
PROC sort
PROC Freq
PROC Contents
PROC Summary
PROC Tabulate
PROC Rank
PROC Print
PROC Report
PROC Univariate etc…
Module 9: Using Basic Graphs and Statistical Procedure
Producing Statistics with PROC MEANS
Producing Statistics with PROC MEANS
Creating Bar Charts
Creating Histograms
Creating Scatter Plots
- Module 5: Formatting Data Values
Variables Attributes
Understanding Numeric Expressions and Assignment Statements
Missing Values
Character Variables
Numeric Variables
Date variables
Currency Variables
- Module 6: Modifying and Combining SAS Data Sets
Modifying a Dataset using the SET statement
Using Data statement to Stack multiple data sets
Using Data statement to Merge multiple data set
- Module 7: Manipulating and Transforming Data
Informants and Formats
Data Set Option (Drop, Keep, Firstobs, Obs)
PROC STEP
- Module 8: Producing Detailed and Summary Reports
Using PROC means
PROC sort
PROC Freq
PROC Contents
PROC Summary
PROC Tabulate
PROC Rank
PROC Print
PROC Report
PROC Univariate etc…
Module 9: Using Basic Graphs and Statistical Procedure
Producing Statistics with PROC MEANS
Producing Statistics with PROC MEANS
Creating Bar Charts
Creating Histograms
Creating Scatter Plots