Adv. SAS Course Info

Power Point and Sample Code

Additional Demonstrations for Reading and Writing Raw Data

Sample Code

Reversing the raw data reading processes to write raw data files

Creating single observations from multiple rows in raw data

Reversing the raw data reading processes to write multiple rows to raw data files from single observations

Reading multiple records from a single raw data line using the double trailing @

Structured Query Language (SQL) in SAS

Using SQL in SAS

Sample Code

More Details for SQL Queries

Sample Code: SQL Concepts, including subqueries

Conditional Logic and Formats

Joining Data Sets Using SQL

Sample Code

Vertical Combinations with Set Operators in SQL

Sample Code

SAS Macro Language

Introduction to the SAS Macro Facility

Basics

Variable Values and Resolution

Creating Macros

Sample Code

More with Macro Parameters/Variables

Sample Code

Conditional Logic in the Macro Language

Sample Code

Creating Macro Variables in the Data Step

Starter Code

Sample Code

Conditional Loops in Macro Language

Sample Code

Deriving Macro Variable Values from Data and Iterative Loops

Sample Code

Sample Code for: Creating Macro Variables in SQL

General Examples

Data Set Concatenation Example, versions 1 & 2

SeaNet Data Read

Simulations: Starter Code

Module for Two-Sample t-test

Module for Two-Sample t-test--Extension 1

Module for Two-Sample t-test--Extension 2

Module for Two-Sample t-test--Extension 3

Storing & Using the Module

Bootstrapping: Starter Code