From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Unlock the full course today
Join today to access over 24,900 courses taught by industry experts.
Challenge: Delete rows - SAS Tutorial
From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Challenge: Delete rows
(upbeat music) - [Instructor] In this challenge, we're going to practice a strategy for deleting rows from a dataset in SAS. This time, instead of BRFSS, we are going to use the NHANES dataset. Please see the handout with this challenge for more details about this dataset. NHANES stands for National Health and Nutrition Examination Survey, and the key word in that title is examination. NHANES is like BRFSS in that it includes a lot of the same questions from questionnaires in the BRFSS. But here's where NHANES is different in an important way. It includes data from in-person examinations, which is why the E in NHANES stands for examination. Because they have to measure everyone in person in NHANES, it's a much smaller dataset than BRFSS, which is done on the phone. Another difference with NHANES is that the datasets are split up depending upon the questionnaire or examination. This is different from the core BRFSS dataset, which is just one big table. For this challenge, we are going…
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)
-
-
-
-
-
-
-