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

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.