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


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.


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.