I need to calculate household size by nativity. Calculating the household size for the total population is straightforward. For this, I divided the total population in households by the total number of households. I used HHTYPE with PERWT to get the population in households and RELATE = 1 with HHWT to get the number of households.
I am having trouble with getting the population living in foreign-born households (I have the total number of foreign-born households) as a foreign-born head of household can have native-born members. Therefore, a crosstab by nativity will only produce households with only native-born OR only foreign-born members. To get the household size for foreign-born households I would need to divide the total population in households (irrespective of nativity) by the total number of foreign-born (or native-born) households. However, all combinations I have tried give me only the foreign-born population in foreign-born households.
What combinations of variables do I need to all persons in foreign-born or native-born households?
SAS or SPSS syntax would also be helpful.