Status:Closed    Asked:Jun 11, 2018 - 09:52 AM

Earnweek value of "999999"

I am pulling monthly CPS data from 1990 to 2018 including the earnweek variable for analysis in STATA. According to its documentation, earnweek has a NIU code of 9999.99 and topcodes of 1923 (1990-1997) or 2885/2884.61 for 1998 onward. It then refers you to the user note on topcodes, but that user note and the accompnaying top codes table don't include any reference to earnweek besides "With the exception of the variable, EARNWEEK, IPUMS code notation only identifies Top Codes that have been imposed by IPUMS coding itself.” While the data contains both the 9999.99 code and the topcodes such as 2884.61, the data also includes the number, 999999, which is not listed in the variable documentation. I am assuming that this also refers to NIU but wanted to confirm as it is not listed in the variable documentation. Thanks!

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


This could probably be explained better in the documentation, but yes the EARNWEEK code 999999 == NIU for basic monthly samples prior to 1994. You can always verify this by checking the values of ELIGORG and AGE, as these variables help define the universe for EARNWEEK.


Jun 11, 2018 - 01:28 PM

Report it


What is a good inc variable in monthly CPS? Using 92-12 data earnweek and hou...
Contrary to documentation does EARNWEEK have two implied decimal points?
"Earnweek" Variable in ATUS
stata version of CPS, EARNWEEK for ASEC sample, years before 1989
Login   |   Register

Recently Active Members

View More »

Share |