Status:Closed    Asked:Nov 08, 2018 - 04:19 PM

AHTUS Missing State IDs

Hi, I downloaded an AHTUS extract with all samples from 1993 to 2012. There are over 3 million observations, but only about 150,000 have state information. Why is this?

Do you have the same question? Follow this Question

Staff Answer

It sounds like you are working with a hierarchical extract, which would be why the state information appears to be missing. In this format, the data contains person records followed by the activity records. As such, you will only have one observation (row) per person containing information such as state, age, sex, etc. We have a bit of information on rectangular versus hierarchical data here.

If you revise your extract to be rectangular, you will see that you have about 150,000 observations total, all with state information.


Nov 12, 2018 - 10:18 AM

Report it


AHTUS to ATUS activity code crosswalks
How to match AHTUS-X with ATUS-X data?
Time range as column for ATUS, AHTUS, MTUS dataset
Are spouse time diaries available for the 1975 AHTUS sample?
Login   |   Register

Recently Active Members

View More »

Share |