Introduction to the basics of SAS and EXCEL focusing on the set of commands useful for data-reporting, data-management, formatting and graphics, and data-analysis. Topics include tables and regression models for epidemiologists (cumulative-incidence, case-control, and incidence rate data).

Prerequisites

Principles Epidemiology (HLTH 345 or equivalent)
Principles of Statistics (STAT 121 or equivalent)

Course Outline

Lesson 1: Getting Started with SAS

Lesson 2: Exploring Data Using Data Dictionaries and the PRINT Procedure

Lesson 3: Exploring SAS Data Using the Frequency (FREQ), Means, and Univariate Procedures, and How To Save Your Output

Lesson 4: Entering Data into SAS Using the DATALINES Procedure; Importing Excel, Access, STATA, and SPSS Files into SAS

Lesson 5: Importing SAS Transport Files (.xpt), Text Files (.txt), and ASCII (.dat) Files into SAS

Lesson 6: Combining Two Data Sets Using Merging and Concatenation; Reducing Variables in a Data Set through DROP/KEEP Commands

Lesson 7: Data Cleaning Rules, an Introduction to IF-THEN Logic Code, and Removing Invalid Responses from Categorical and Continuous Variables

Lesson 8: Simple Recoding of Categorical Variables

Lesson 9: Alternate Methods for Recoding Categorical Variables (e.g., OR, IN, BETWEEN, and Elimination)

Lesson 10: Converting Continuous Variables into Categories and Using Continuous Variables to Perform Calculations

Lesson 11: Using Comments to Annotate Your SAS Code, and Applying Labels to Variables and Using Titles to Improve SAS Output

Lesson 12: Creating and Applying Formats, Using the ORDER=FORMATTED Option to Customize Output Displays

Lesson 13: Combining Two or More Variables Using Conditional Recoding

Lesson 14: Conditional Recoding of Check-All-That-Apply Questions

Lesson 15: Using a DO Group to Simplify Conditional Recoding

Lesson 16: Using Arrays to Recode Multiple Variables and an Introduction to MACRO Variables

Lesson 17: Basic Data Analysis for Categorical Variables (Chi-Square, Relative Risk, Odds Ratio)

Lesson 18: Stratified and Subpopulation Analysis

Lesson 19: Logistic Regression

Lesson 20: Brief Introduction to Using Excel and Proc Compare in SAS

Lesson 21: Formulas and Equations in Excel

Lesson 22: Creating Tables in Excel

Lesson 23: Charts and Graphs in Excel

Lesson 2: Exploring Data Using Data Dictionaries and the PRINT Procedure

Lesson 3: Exploring SAS Data Using the Frequency (FREQ), Means, and Univariate Procedures, and How To Save Your Output

Lesson 4: Entering Data into SAS Using the DATALINES Procedure; Importing Excel, Access, STATA, and SPSS Files into SAS

Lesson 5: Importing SAS Transport Files (.xpt), Text Files (.txt), and ASCII (.dat) Files into SAS

Lesson 6: Combining Two Data Sets Using Merging and Concatenation; Reducing Variables in a Data Set through DROP/KEEP Commands

Lesson 7: Data Cleaning Rules, an Introduction to IF-THEN Logic Code, and Removing Invalid Responses from Categorical and Continuous Variables

Lesson 8: Simple Recoding of Categorical Variables

Lesson 9: Alternate Methods for Recoding Categorical Variables (e.g., OR, IN, BETWEEN, and Elimination)

Lesson 10: Converting Continuous Variables into Categories and Using Continuous Variables to Perform Calculations

Lesson 11: Using Comments to Annotate Your SAS Code, and Applying Labels to Variables and Using Titles to Improve SAS Output

Lesson 12: Creating and Applying Formats, Using the ORDER=FORMATTED Option to Customize Output Displays

Lesson 13: Combining Two or More Variables Using Conditional Recoding

Lesson 14: Conditional Recoding of Check-All-That-Apply Questions

Lesson 15: Using a DO Group to Simplify Conditional Recoding

Lesson 16: Using Arrays to Recode Multiple Variables and an Introduction to MACRO Variables

Lesson 17: Basic Data Analysis for Categorical Variables (Chi-Square, Relative Risk, Odds Ratio)

Lesson 18: Stratified and Subpopulation Analysis

Lesson 19: Logistic Regression

Lesson 20: Brief Introduction to Using Excel and Proc Compare in SAS

Lesson 21: Formulas and Equations in Excel

Lesson 22: Creating Tables in Excel

Lesson 23: Charts and Graphs in Excel

Syllabus

Textbooks

BYU Store | Library | |
---|---|---|

An Intro to Statistical Computing Using SAS in Epidemiology (packet) (Required)ISBN: 9780700301645 BYU Packet |
New: $25.00 |
Borrow |

Other Materials

Digital SoftwareRequiredAccess to the SAS computer program is required. This software is currently available free of charge through SAS University Edition. A high-capacity flash drive may be desirable if you do not wish to save large data files to your computer hard drive. Free version

Monday–Friday (except holidays)

8:00 a.m.–5:00 p.m. mountain time

Harman Continuing Education Building (HCEB)

770 E University Pkwy

Provo UT 84602

116 HCEB

770 E University Pkwy

Provo UT 84602

Local: 801-422-8925

Toll-free: 1-877-221-6716