Status:Closed    Asked:May 30, 2017 - 11:52 AM

I want to select cases by MISH, but it's not an option.

I am extracting a dataset that is primarily at the person level, but I only want to look at one month-in-sample rather than having households appear multiple times in the data. Selecting cases by MISH would greatly reduce the size of my data extract, which is quite large since it comprises all basic data since 1994. Why isn't MISH listed as an option for selecting cases? I realize that it's a household variable while I am using people, but it's a variable that is completely consistent over the years and there are numerous reasons why a researcher might want to only look at samples at certain points in their rotation. Thanks.

Do you have the same question? Follow this Question

Staff Answer




This is a very good suggestion and I will pass this along to the IPUMS CPS team to consider for their next data release. In the mean time, a more tedious solution would be to break up your extracts into smaller chunks of samples. You can then select the MISH value from within your statistical software, dropping all other cases, and save the subsetted files. Since these sets of samples will include all of the same variables you should then be able to append them all together resulting in your desired, single MISH data file.

I hope this helps.


Jun 02, 2017 - 09:06 AM

Report it


The highest one percent incwage earners are combined into the incwage"Top Cod...
To compute unemployment rates from Ipums-I, should I use perwt as pweights or...
Why is the income wage variable incwage-capped? and how is the cap determined...
USA IPUMS 1980 ancestry variable -- mapping to country names
Did the version of database change since 2011?
Are DATANUM, SERIAL, and PERNUM the same in single-year and 5-year ACS sample...
Login   |   Register

Share |