541—Advanced SAS Programming. (3) (Prereq: STAT 540) Advanced programming techniques in SAS, including database management, macro language, and efficient programming practices.

Sample Course Homepage: Recent Semester

Usually Offered: Spring semesters

Purpose: To help students learn advanced SAS computing programming skills, including SQL queries; data management, modification and formatting; and SAS macro programming. To help students learn efficient methods of SAS programming.

Current Textbook:
SAS Certification Prep Guide: Advanced Programming for SAS 9, Third Edition, by SAS Institute Inc..

 

Topics Covered	Time
PROC SQL (Queries, joins, table creation and management, indices and views)	4 weeks
Macro variables, macro programs and macro storage	4 weeks
Creating and combining data	1 week
Lookup tables; formatting data and modifying data sets	3 weeks
Efficient SAS Programming and best practices; efficient sorting and queries	2 weeks

 

The above textbook and course outline should correspond to the most recent offering of the course by the Statistics Department. Please check the current course homepage or with the instructor for the course regulations, expectations, and operating procedures.  

Contact Faculty: John Grego