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


I am looking for the Kessler 6 variable in IPUMS-MEPS
Reason for missing MIGSTA1 values in ASEC files for 1985 (and 1995)
India Area-level data (geo2) inconsistent for total population, urban share, ...
Does anyone have a method for handling missing data in CPS "EDUC" variable? 2...
How do I find the data file:Ipumsi_00001.dat for the 1974
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Login   |   Register

Recently Active Members

View More »

Share |