What are the best variables for merging the ATUS activity and who files?


#1

I’m using the ATUS wellbeing module so I need to use the hierarchical data. I downloaded the data in Stata and sucessfully separated it by record type. I have recoded the who data in the way that I need but I’m having a hard time merging it back in with the activity data. What are the best variables to use for that merge?

Thank you.


#2

The variable ACTLINEW in the who records corresponds to the line number (LINENO) of the associated activity record. Therefore, you will want to merge on YEAR, CASEID and ACTLINEW/LINENO.

Hope this helps.