From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Updating data reduction documentation - SAS Tutorial
From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Updating data reduction documentation
- [Instructor] See the spreadsheet I have open in Excel? It's named data reduction. This spreadsheet is in your exercise files for this movie. If you are thinking the spreadsheet looks suspiciously familiar, it should. I went over this data reduction documentation when I covered curation files in the prerequisite courses. As I mentioned in the last movie, readers of your final report will want to know about selection bias. And so, you'll have to keep track of how many rows you removed at each step. This is the format of the spreadsheet I recommended you keep from the data you see in the log file so later you have these numbers and can write about them. Let's take a closer look. See our old friend 464,664? Remember, that is the number of rows in BRFSS_A, the first iteration of the data set. Now see here, I describe the criterion for exclusion, not a veteran. So how many people are not a veteran? The answer is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Alternatives to labels and formats4m 11s
-
(Locked)
Using PROC FREQ to prepare5m 5s
-
Removing rows by categorical criteria6m 21s
-
(Locked)
Removing rows by continuous criteria4m 38s
-
(Locked)
Removing rows where values are missing6m 38s
-
(Locked)
Observations from the log file6m
-
(Locked)
Updating data reduction documentation5m 36s
-
(Locked)
Challenge: Delete rows4m 23s
-
(Locked)
Solution: Delete rows1m 51s
-
(Locked)
-
-
-
-
-
-
-