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




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

Report it


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...
why the number of households by income bin using individual-level data does n...
Login   |   Register

Recently Active Members

View More »

Share |