Question

Status:Open    Asked:Feb 13, 2018 - 04:46 PM

replicating BLS employment levels with IPUMS CPS

Hi, I am trying to replicate BLS employment levels for specfic industries. I used this table (https://usa.ipums.org/usa/volii/indcr...) to create a dummy variable for the NAICS categories. I am trying to compare 2014 employment numbers in my data to this table provided by BLS: https://www.bls.gov/opub/ee/2015/cps/.... This is my code in stata:


tab NAICS if year == 2014 [iw=wtfinl]


NAICS is my dummy variable I created using IND for the NAICS industry codes. Although I come up with the same percentage distribution for the industries as BLS does, I am coming up with crazy numbers. For example for mining, the frequency I get with my data is 13,833,783, but the BLS employment level for mining in 2014 is 1,088,000. Any idea why this might be happening?

 
Do you have the same question? Follow this Question
 

Staff Answer

I think the issue may be that you are summing frequencies for multiple sample months in 2014. I believe the report you have provided from the BLS is reporting annual averages. Try computing an annual average; I think your numbers will be much closer.

 

Feb 14, 2018 - 04:15 PM

0
0
Report it

Yes, that should also work. There will be a difference in the frequencies between the two methods, but it should be very small.

 

Feb 15, 2018 - 11:05 AM

0
0
Report it

Answers

Thank you that worked! Before you answered, I tried doing what CEPR suggests doing to their CPS ORG data (here: http://ceprdata.org/cps-uniform-data-...) which is generating a new weight by taking wtfnl, dividing it by 12 and rounding to the nearest integer. Would that also work?


Thank you!

 

Feb 14, 2018 - 04:52 PM

0
0
Report it

Yes, that should also work. There will be a difference in the frequencies between the two methods, but it should be very small.

 

Feb 15, 2018 - 11:05 AM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Change in CPS EMPSTAT (A-LFSR Labor force status recode) in 2001?
I have an extract 2001 to 2015. Total number of people: 4 million, but in bir...
Why are there fewer counties in the 1950 1% sample compared to the 1940 1% sa...
Is the value of INCWKCOM included in the value of INCDISAB?
Trying to access CPS online analysis tool
ACS METRO variable construction
Login   |   Register

Recently Active Members

View More »

Share |