Status:Closed    Asked:Apr 04, 2016 - 04:09 PM

How to idenitfy households with 1 or more members who meet specific criteria?

We want to create a variable that tells us if one or more members of a household meet a specific set of age and sex criteria. The results would be households where 1 indicates that one or more members meet the criteria and 0 indicates that none of the members meet the criteria.

Can this be done by recoding data with the on-line tool and if not what software is recommended?

Do you have the same question? Follow this Question

Staff Answer




Unfortunately, the online data analysis system cannot create variables based on the characteristics of multiple records. You will need to use statistical software to perform this analysis, unless your data extract is small enough to open in Excel. We generate command files with each data extract that can be used to read IPUMS data into Stata, SAS, or SPSS. Many of our users also use R, which is a free open-source project (see this document for more information on using IPUMS data in R).

Hope this helps.


Apr 06, 2016 - 04:59 PM

Report it


How to identify members of the military?
Computing household counts based on individual-level characteristics of house...
I need to find the number of households in the US with any members aged 13-17...
In the USA PUMS file is there pointer variable to give members of a household...
Login   |   Register

Recently Active Members

View More »

Share |