Why do I get only 0 values for Vacancy variable (that is only non-vacant units)?

I am trying to obtain all observations for non-vacant as well as vacant units. But my samples are limited only to non-vacant units, that is Vacancy = 0. I know the samples also contain vacant units, and would like help with pulling those observations.

1 Like

Because the default rectangular structure of the data places all household information on the person record, households with no associated person records (vacant households) are effectively dropped from the extract. If you wish to download an extract with all households included, you can choose to create a hierarchical extract from the extract request menu by changing Structure to “Hierarchical.”

Hope this helps.