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