Status:Closed    Asked:Sep 02, 2018 - 09:55 AM

How can I determine how many people live in a household with at least one non-citizen in 2016 ACS?

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


With the 2016 ACS data, the CITIZEN variable identifies the information you are looking for. The trick will be converting this person-level variable to a household-level variable. I'd first generate a person-level dummy variable equal to 1 if CITIZEN==3 "Not a citizen". Then, I'd generate a household-level variable if there is at least one value of the person-level dummy variable equal to 1 within a given household (based on SERIAL). Third, convert your person-level data set into a household-level data set by keeping only observations with PERNUM==1. Finally, run a tabulation using the household-level sampling weight (HHWT). The specific details on how to perform these steps will depend on the specific statistical software you are using. For example, if you are using Stata, one way is to perform the following commands:

generate non_citizen = 1 if citizen==3
replace non_citizen = 0 if citizen!=3
by serial, sort: egen non_citizen_hh = max(non_citizen)
keep if pernum==1
tab non_citizen_hh [fweight = hhwt]


Sep 04, 2018 - 11:24 AM

Report it


Head of Household in ACS data
Want to determine the number of people employed by SOC code by MSA and what p...
What's the diff between ACS and 1% sample in year 2000? Is ACS 2016 & 1% 2000...
Is everyone in the household answer the ACS survey?
Login   |   Register

Recently Active Members

View More »

Share |