A second course in statistical computing, using the SAS
programming language to read data, create and manipulate SAS
data sets, writing and using SAS MACROS, and SAS programming
efficiency. SAS-based implementation of Structured Query
Language (SQL). Additional topics may include Hadoop and
parallel computing.
Additional Requirements for Graduate Students: Additional and/or alternative problems of a more challenging
nature will be required for graduate students on homework
assignments and exams.
Athena Title
Adv Statistical Programming
Undergraduate Prerequisite
STAT 2010 or STAT 2100H or STAT 2360-2360L
Graduate Prerequisite
STAT 6220 or STAT 4230/6230 or STAT 6315 or STAT 6315E or STAT 6420 or STAT 8200 or permission of department
Semester Course Offered
Not offered on a regular basis.
Grading System
A - F (Traditional)
Student Learning Outcomes
Students will differentiate between a temporary and permanent SAS data set.
Students will identify types of variables.
Students will define the uses of punctuation (semicolon, colon, period) in SAS.
Students will import raw data files in SAS.
Students will export raw data files in SAS.
Students will combine SAS data sets.
Students will create basic detailed reports using SAS procedures.
Students will create summary reports using SAS procedures.
Students will identify data errors in SAS.
Students will identify syntax errors in SAS.
Students will identify programming logic errors in SAS.
Students will correct data errors in SAS.
Students will correct syntax errors in SAS.
Students will correct programming logic errors in SAS.
Students will outline program steps before writing code.
Students will use advanced DATA step programming statements to solve problems.
Students will use advanced DATA step efficiency techniques to solve problems.
Students will write SAS SQL code.
Students will manipulate data using SQL.
Students will query relational databases using SQL.
Students will join tables using SQL.
Students will interpret SAS SQL code.
Students will create SAS macro variables.
Students will use SAS macro variables.
Students will create with the SAS macro facility.
Students will use the SAS macro facility.
Students will communicate the results of statistical analyses through oral and written means.
Topical Outline
accessing data using the DATA step
managing and manipulating data via DATA step processing
