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)
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
- Introduction to SAS
- Creating permanent SAS datasets
- SAS Libraries
- Reading raw data from external files
- Intro to PROC Print, PROC Freq, and PROC Means
- PROC Contents
- Creating formats and labels
- Reading and writing data from an Excel spreadsheet
- PROC Import with a twist
- PROC Datasets
- Conditional processing
- Subsetting and combining SAS datasets
- Working with dates
- About SAS Date, Time, and Datetime values
- Anydate informat
- Working with numeric functions
- Working with character functions
- Put and Input
- Displaying your data (PROC Print)
- Global statements (titles, footnotes, system options)
- Introducing the Output Delivery System (ODS)
- Summarizing your data (PROC Means)
- Counting frequencies (PROC Freq)
- Creating customized reports (PROC Report)
- Creating tabular reports (PROC Tabulate)
- Introduction to SQL
- Iterative processing and looping
- Working with multiple observations per subject
- By group processing
- Working with arrays
- Introduction to SAS Macro Language
- CALL SYMPUT
- Generating high quality graphics
- 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.