Question

Status:Closed    Asked:Dec 29, 2014 - 09:34 AM

What weighting procedure do I use to calculate the state-year level mean for an individual-level variable?

I want to use the 1980, 1990, and 2000 census data along with the 2001-2012 ACS data to calculate the state-level mean for individual-level variables, e.g. VETSTAT. I am using STATA 13.


How should I use weights to accomplish this task?

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Tim_Moreland

Staff

When performing a weighted person-level analysis, you should always weight your data with the PERWT variable. The value of PERWT indicates how many persons in the population are represented by each sample case. You can then calculate the mean by state (STATEFIP) in STATA.The STATA code would look something like this:


bysort statefip: summarize vetstat [weight=perwt], meanonly


Depending on your purposes, you may wish to create a different version of a variable like VETSTAT in order to create more meaningful results (i.e. create a 1/0 flag indicating veteran status). Additionally, if you are concerned with estimating variance, then please see this User's Note on how to account for the complex survey design.


Hope this helps.

 

Dec 30, 2014 - 01:41 PM

0
1
Report it

Answers

This doesn't seem to work. When I am summing PERWT by year, I get a pretty accurate estimate for the total population of the United States. But when I sum it by state-year - I get nothing close to the true population in each state. It seems like the weights are adjusted at the national level and not at the state level.


Am I missing something?

 

May 23, 2018 - 10:39 AM

0
0
Report it

My bad, I used work place state instead of STATEFIP.

Sorry... It works fine!

 

May 23, 2018 - 11:55 AM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

If you are examining individual level data, can you use the state FIPS codes?
Data at the individual level for migration flows
How best to aggregate data to a state level?
Can I use weights to calculate the monthly unemployment rate for the sub-nati...
Login   |   Register

Recently Active Members

View More »

Share |