Duration : 60 Hrs | 1hr theory/day 1hr Practical

Introduction

course logistics

overview of Foundation SAS

SAS syntax review

navigating the SAS windowing environment (self-study)

 

Getting Started with SAS

introduction to SAS programs

submitting a SAS program

 

Working with SAS Syntax

mastering fundamental concepts

diagnosing and correcting syntax errors

 

Getting Familiar with SAS Data Sets

examining descriptor and data portions

accessing SAS data libraries

accessing relational databases (self-study)

 

Reading SAS Data Sets

introduction to reading data

using SAS data as input

subsetting observations and variables

adding permanent attributes

 

Reading Excel Worksheets

using Excel data as input

doing more with Excel worksheets (self-study)

 

Reading Delimited Raw Data Files

using standard delimited data as input

using nonstandard delimited data as input

 

Validating and Cleaning Data

introduction to validating and cleaning data

examining data errors when reading raw data files

validating data with the PRINT and FREQ procedures

validating data with the MEANS and UNIVARIATE procedures

cleaning invalid data

 

Manipulating Data

creating variables

creating variables conditionally

subsetting observations

 

Combining SAS Data Sets

introduction to combining data sets

appending a data set (self-study)

concatenating data sets

merging data sets one-to-one

merging data sets one-to-many

merging data sets with nonmatches

Enhancing Reports

 

using global statements

adding labels and formats

creating user-defined formats

subsetting and grouping observations

directing output to external files

 

Producing Summary Reports

using the FREQ procedure

using the MEANS procedure

using the TABULATE procedure (self-study)

 

Introduction to Graphics Using SAS/GRAPH (Self-Study)

creating bar and pie charts

creating plots

enhancing output

 

Controlling Input and Output

outputting multiple observations

writing to multiple SAS data sets

selecting variables and observations

 

Summarizing Data

creating an accumulating total variable

accumulating totals for a group of data

 

Reading Raw Data Files

reading raw data files with formatted input

controlling when a record loads

additional techniques for list input (self-study)

 

Data Transformations

manipulating character values

manipulating numeric values

converting variable type

 

Debugging Techniques

using the PUTLOG statement

using the DEBUG option

 

Processing Data Iteratively

DO-loop processing

SAS array processing

using SAS arrays

 

Restructuring a Data Set

rotating with the DATA step

using the TRANSPOSE procedure

 

Combining SAS Data Sets

using data manipulation techniques with match-merging

 

Other SAS Languages

an overview of other languages

using the SQL procedure

the SAS macro language

Related course

 

Related Links