We’re using modified public use files from Wave 1 and 2 of the Add Health Study. The SAS data and
data dictionaries are attached, in addition to a crosswalk explaining
the variable names in the provided dataset.
Instructions
1. You are manipulating data in SAS to create an interactive Tableau dashboard for this assignment
instead of the one-page report we used in the previous three quarterly reports
2. The dataset has multiple observations per subject
a. Specifically, there can be 1-2 rows per subject that are identified by the variable “wave”
b. Wave=1 means the data are from the Wave 1 interview, and Wave=2 means the data
are from the Wave 2 interview
3. The dataset contains demographic variables and items on health care access
a. There is not an age variable, but you can figure out generally how old subjects were in
each wave from the study methodology
4. You must manipulate the data in SAS
5. Your interactive Tableau dashboard needs to include a minimum of 3 graphs
b. Correctly labeled axes, titles, legends, and visual appeal will be graded
c. Each graph needs an interactive component (i.e. hovering over a point on a line graph
displays the value for that point)
d. You must use data from both Waves 1 and 2
6. The dashboard needs a title, descriiption of the Add Health Study and data used in this activity
a. It needs to show how many subjects responded to Wave 1, Wave 2, and both Waves
7. Do not use raw variable names on any part of the project!
8. Overall visual appeal will be graded
a. Be mindful of too much text and use buttons
9. You must include a minimum of five (5) variables from the dataset in the dashboard
10. Deliverables for submission:
a. SAS Log, Program, and Output files saved using the lastname_type of SAS file naming
convention
b. Tableau workbook saved using the lastname_workbook naming convention