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


Underlying files for CPS Education Supplements (October)?
Income varialbe values & US variable
Why there is no data for 'VLHALLORG"
.CVS format data uploaded into EXCEL
County Codes
Strange universe - ASEC SDA labor force questions
Login   |   Register

Recently Active Members

View More »

Share |