Assignment 5: Final data management The purpose of Assignment 5 is to give you

Assignment 5: Final data management
The purpose of Assignment 5 is to give you the opportunity to provide any remaining data management tasks required to complete the table shells for your final project. The required tasks will vary student by student. Use the following steps as a guide.
Step 1: Create the final version of all variables you will use for analysis
Recode missing value codes (e.g. 7, 9) as missing ( . )
If needed, compute new variables using arithmetic functions
If needed, collapse categories of existing categorical variables
If needed, create categorical variables from continuous variables
Use a LABEL statement to make sure that all variables are labeled
Use a PROC format statement to create formats for all categorical variables in your data file
Step 2: Create a final analytic data file that includes only individuals with valid data for your primary exposure and outcome variables
Subset observations in your analytic data file to include only individuals that will be included in your analysis (e.g. you may need to limit your data file based on your population of interest)
Subset columns in your analytic data file to include only variables that will be used in your analysis in addition to SEQN, the participant unique identifier.
Step 3: Run PROC CONTENTS and PROC PRINT (obs=50) to examine your analytic data file
Step 4: Update the codebook you created in Assignment 2 using your revised analytic data file
Variable NameNHANES Data SourceVariable DescriptionVariable TypeN / NMiss% (N) or Mean, Std, Min, Median, Max
Var 1
Var 2
Var 3
Step 5: Submit your SAS Log (make sure errors are resolved before submitting) and your updated codebook.
Assignment 6: Completed tables for final project
This week you are submitting your completed final project tables!
These include:
Table 1 (required): Description of the study sample with stratification by levels of exposure variable
Table 2 (required): Results from your primary analysis
Figure (optional): A graph visualizing some aspect of your data analysis
Use the feedback you received from Assignment 4 to structure your tables. The specific structure will vary depending on the research question you choose. If you have lingering questions surrounding the specific format of your tables, please contact the instructor. The rubric is provided below.