STA 5067 Advanced SAS

SQL Displaying Queries

Lecture

Ordering Queries

Using Summary Functions

Remerging

By Group, Having

Grouping With Boolean Conditions

Some Examples

Framingham, Exam 5 subset

Summarize Simulated Data

Demonstrating Regression

Create a subset with the IN operator

Meta Analysis Fixed Effects with SQL

Meta Analysis Fixed Effects with SQL, Individual Level Data

Create a complete case table

Create a life table using SQL