Question

Status:Closed    Asked:Apr 12, 2016 - 06:06 PM

Comparing across 1980, 1990, 2000 Census and 2006-2008 3 year ACS

Hi,


I am currently using 1980, 1990, 2000 Census, and 2006-2008 3 year ACS to build up the database. But it seems that Census and ACS database are quite different in terms of sample representativeness even after I adjust with "perwt" variable.


For example, if I simply sum up the population and employment within year after adjusting with "perwt" variable, I am getting the following number:


year 1980: employment 4,949,357; total population 1.13e+07

year 1990: employment 5,902,657; total population 1.25e+07

year 2000: employment 6,546,089; total population 1.41e+07

year 2008: employment 4,293,972; total population 8,965,060


Employment is based on "empstat" variable. I expected larger number of employment and total population for the year 2008, but number gets smaller. That is, it seems that ACS and Census are not compatible even after I adjust with "perwt" variable.
Do I need to further adjust the ACS database to make it compatible with Census database? Your help would be greatly appreciated!

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Tim_Moreland

Staff

The numbers you report are unweighted. Using your extract #13 and weighting your samples by PERWT, I get the following values for EMPSTAT=1:


1980: 98,987,140
1990: 117,161,898
2000: 130,869,287
2008 3-yr: 144,283,042


As you can see, the estimated number of employed persons in the U.S. increases over time, as you expected. The syntax for generating weighted counts varies depending on the statistical software you are using. In Stata, try the following: tab year empstat [fweight=perwt].


Hope this helps.

 

Apr 14, 2016 - 02:01 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Potential effects of sample size expansion in CPS: March 2000 to March 2001
negative values of wtsupp 1975 and before
MPC Note: Programming error applying inflation adjustment to multi-year ACS f...
Why are not all the "not in the labour force" categories filled for the EMPST...
Population living in foreign-born households
Login   |   Register


Share |