SAS Essential Training: 1 Descriptive Analysis for Healthcare Research

Course details

After literally decades on the scene, SAS is still an industry leader in the world of big data. If healthcare analytics piques your interest—and you want to get up and running with this venerable data analytics platform—then this course is for you. Join instructor Monika Wahi as she steps through how to conduct a descriptive analysis of a health survey dataset and present the results in plots and tables. Monika covers how to import a dataset from SAS *.xpt format using the XPORT command; edit datasets to add new categorical and continuous variables; conduct chi-square tests, t-tests, and analyses of variance (ANOVAs); generate a descriptive analysis with either a categorical and a continuous dependent variable; and more.

Learning objectives
Preparing hypotheses and research aims
Applying exclusions to a big dataset
Removing rows by categorical and continuous criteria
Finalizing an analytic dataset
Generating bar, pie, box, and scatter plots
Developing tables presenting descriptive analysis results
Conducting t-tests and one-way ANOVAs
Alternative approaches to descriptive analysis
Tricks for displaying descriptive results in Excel

Concepts

0. Introduction

01 - SAS essential training - Descriptive analysis
02 - What you should know

1. Preparing for Analysis

03 - BRFSS dataset and documentation
04 - Organizing your work
05 - Hypotheses for the demonstration
06 - Explanation of SAS XPT
07 - Reading in SAS XPT file
08 - KEEP and DROP commands
09 - Reviewing confounders

2. Applying Exclusions

10 - Alternatives to labels and formats
11 - Using PROC FREQ to prepare
12 - Removing rows by categorical criteria
13 - Removing rows by continuous criteria
14 - Removing rows where values are missing
15 - Observations from the log file
16 - Updating data reduction documentation
17 - Solution - Delete rows

3. Developing the Analytic Dataset

18 - Recoding a grouped variable
19 - Recoding the smoking variable
20 - Creating flags - Indicator variables
21 - Grouping a continuous variable
22 - Cleaning a continuous variable
23 - Completing the analytic dataset
24 - Challenge - Make a categorical variable from a continuous one
25 - Solution - Make a categorical variable from a continuous one

4. Helpful Plots

26 - Bar chart
27 - Pie chart
28 - Histogram
29 - Box and whisker plot
30 - Scatter plot
31 - Challenge - Make a scatterplot
32 - Solution - Make a scatterplot

5. Categorical Descriptive Analysis

33 - Choosing an analytic approach
34 - Creating a categorical table shell
35 - PROC FREQ with options
36 - Putting results in a table
37 - Chi-square and Fisher s exact tests

6. Continuous Descriptive Analysis

38 - Normal plot
39 - Creating a continuous table shell
40 - PROC SORT and PROC UNIVARIATE
41 - Transferring continuous results to a table
42 - Conducting t-tests
43 - Conducting one-way ANOVAs

7. Alternative Approaches to Descriptive Analysis

44 - Tricks in Excel
45 - PROC TABULATE for categorical analysis
46 - PROC TABULATE for continuous analysis
47 - Explanation of the ODS
48 - Example of ODS and PROC FREQ
49 - Example of ODS with PROC UNIVARIATE

8. Tips and Tricks

50 - Using weights with PROC FREQ
51 - Recoding into quartiles
52 - Creating an index variable
53 - Using the Import wizard
54 - Sorting and merging
55 - Introduction to PROC SQL

Conclusion

56 - Review of the process
57 - Next steps