SAS Notes

Using SAS in the SSCC

• Using SAS in the SSCC
  • Windows vs. Linux
  • Interactive vs. batch
• Launching SAS from a Command Line
• Launching SAS from the Windows Explorer
• Customizing Your SAS Configuration
  • Setting CPUCOUNT

Using the SAS Windows (DMS)

• Introduction to the SAS Windowing Environment (SAS 9.4 Language Reference)
• Main Windows in the SAS Windowing Environment (SAS 9.4 Language Reference)
• Submitting Commands

Working with the SAS Language

Saving and Using SAS Files, and the SAS Language.

• Writing SAS Code
• SAS Files
  • Saving SAS Data
  • Data Set Options
  • Saving SAS Output
  • Saving SAS Graphs

Working with Large Data Sets

• SAS Efficiencies
• Where to Store Data
• Compressed Data
• Importing Large Text Files
• Optimizing System Performance (SAS 9.4 Language Reference)

Building Data Sets (Data Wrangling)

The DATA step

• The Basic DATA step
• Understanding the DATA step
• Working with Numeric Data
• Working with Character Values
• Converting Numeric/Character Types
• Creating and Using Indictators for Many Categories
• Working with Logical Values
• Conditional Processing: IF-THEN/ELSE
• Statement groups and Iterations: DO/END
• Iterating over variables: Variable Arrays
• Repeated and Duplicate Observations

Beyond the DATA step

• Variable Labels
• SAS Formats
• User-defined Formats (Value Labels)
• Informats to Encode and Order Character Values
• Types of SAS Errors

Reading Data into SAS

• Concepts
• Observations and Records
• INPUT specification

Subsets and Merges

• Subsets
  • Variables
  • Conditional observations
• Merges
  • Add variables, Concatenate, Stack data sets
  • Nuances and trouble-shooting concatenation
  • PROC APPEND and DATASETS
  • Concatenate, Merge, and Match-merge
  • Table lookup techniques

Arrays

• Variable Arrays

Reshaping Data

• Reshape Long
• Reshape Wide

Output Data Sets

• SAS Output as Data
• Utility and Statistical procs
• Output statements and options
• ODS
• ODS example: collecting lsmeans

Common Statistical Procedures

• Frequencies and Crosstabs
• Means
• Weighted Means
• Correlations
• Regression

Graphics

• Common Plots with SGPLOT and statistical procedures

• Saving SAS Graphs

• Three graphics systems

• Finding graphics commands

• Twoway Plot Examples

  • proc sgplot
  • proc gplot

• Categorical Chart Examples

  • proc sgplot
  • proc gchart

Macros

• Macro variables (%Let)

• Simple Macro Programs

• Macros with parameters

• Macro functions and macro flow

• Interleaved output

Writing SAS Documentation

Some notes on how to write up SAS documentation using Markdown and RMarkdown. This is primarily geared toward writing web pages and PDF handouts that include SAS code, SAS output, and explanatory text. This same system can be used to produce simple Word documents.

• The SASmarkdown Package
• SAS and R Markdown
• Linking SAS Code Blocks
• HTML Tables and Graphs
• Including SAS Logs
• Cleaning Up SAS Log Output
• SAS LaTeX tables
• SAS National Language Support
• Saving intermediate files
• spinSAS - Markdown in SAS comments

Running R from SAS

• Configuration and Basic Use