I am getting some weird tabulations for the “sex” variable in the 9/2017 CPS Monthly Supplement. I am using Stata and ran the usual generated IPUMS Stata code for the raw import.
The relevant part of the code is
label define sex_lbl 1
"Male"' label define sex_lbl 2 “Female”’, add
label define sex_lbl 9 `“NIU”’, add
label values sex sex_lbl
As you can see there are three values defined: 1,2 and 9
The Puzzling Tabulation
This is the untransformed sex variable from the raw infile, so it has not been recoded or changed
Yet when I tab sex I get he following
As you can see, there are several undefined values for the sex variable (0, 4, 5). And the percentages seem way off as well. I don’t think the sample is 96% Male and only 0.1% Female-- right?
Any help would be appreciated.
Michael Howell-Moroney, Ph.D.
Department of Public and Nonprofit Administration
School of Urban Affairs and Public Policy
The University of Memphis
315 Browning Hall
Memphis, TN 38152