As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


SAS 101 Trainings (based on Learning SAS by Example)

From sasCommunity
Jump to: navigation, search

by Tasha Chapman

This 14 week training class covers the basics of SAS, including data manipulation, reporting, and some advanced topics.

Using Ron Cody's Learning SAS by Example: A Programmer's Guide as a course textbook,** in addition to other SAS papers and presentations, this 14 week training class covers the basics of SAS. The first five weeks focus on basic data manipulation, including reading raw data into SAS, using formats and informats, functions, conditional processing, and subsetting and joining data sets. The following four weeks cover the basic reporting procedures, including PROC Print, PROC Freq, PROC Means, PROC Tabulate, and PROC Report, as well as the Output Delivery System (ODS). The final five weeks go over advanced topics for intermediate SAS users, such as SQL, SAS/GRAPH, Macros, Arrays, and more.



Basic Data Manipulation


Week 1: Chapters 1 & 2

Introduction to SAS


Week 2: Chapters 3 & 4 (except 3.9 through 3.14)

Creating permanent SAS datasets
SAS Libraries
Reading raw data from external files
Intro to PROC Print, PROC Freq, and PROC Means
PROC Contents


Week 3: Chapters 5 & 6 (and 3.9 through 3.14)

Creating formats and labels
Reading and writing data from an Excel spreadsheet
PROC Import with a twist
PROC Datasets


Week 4: Chapters 7 & 10 (except 10.6, 10.13)

Conditional processing
Subsetting and combining SAS datasets


Week 5: Chapters 9, 11, & 12 (and 10.13)*

Working with dates
About SAS Date, Time, and Datetime values
Anydate informat
Working with numeric functions
Working with character functions
Put and Input



Basic Reporting


Week 6: Chapters 14 & 19

Displaying your data (PROC Print)
Global statements (titles, footnotes, system options)
Introducing the Output Delivery System (ODS)


Week 7: Chapters 16 & 17 (and 10.6)

Summarizing your data (PROC Means)
Counting frequencies (PROC Freq)


Week 8: Chapter 15

Creating customized reports (PROC Report)


Week 9: Chapter 18

Creating tabular reports (PROC Tabulate)



Advanced Topics


Week 10: Chapter 26

Introduction to SQL


Week 11: Chapters 8, 13 & 24

Iterative processing and looping
Working with multiple observations per subject
By group processing
Working with arrays


Week 12: Chapter 25

Introduction to SAS Macro Language
%LET
CALL SYMPUT


Week 13: Chapter 20*

Generating high quality graphics


Week 14: Chapters 21, 22 & 23*

Restructuring SAS datasets (PROC Transpose)
Using advanced features of user-defined formats and informats
Using advanced input techniques
Saving and storing macros


*Due to technical difficulties, original PowerPoint slides for this section are not available to be downloaded at this time. Please e-mail Tasha Chapman for copies of these slides.
**These trainings are not directly affiliated with Ron Cody or his book. They merely use the text as a general guide for the course. If you like what you see here, please support the author and purchase his inexpensive and excellent book Learning SAS by Example: A Programmer's Guide as a companion to this course.




Portions of this training was presented at the Western Users of SAS Software (WUSS) 2014 Conference in San Jose, California.

Find more SOSUG presentations, as well as other tips, tricks, and tools created by or recommended by SOSUG members here.

New versions of these trainings with slightly updated material is available by request.