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


Info on non-primary occupation in CPS?
When did IPUMS-CPS start like the way (easily downloadable way) like now?
Replicate weights for use with CPS-TUS
Longitudinal cohort in TUS 2014/2015?
When can we expect NFHS 4 data to included in IPUMS-DHS database?
Login   |   Register

Recently Active Members

View More »

Share |