Question

Status:Closed    Asked:Apr 18, 2014 - 11:37 AM

What weights should I use to calculate state*year statistics combining info from the March & Oct supplements?

I am interested in looking at the share of young adults who have health insurance and who are enrolled in school, so I would like to combine variables from the March supplement & Oct Education supplement. I am only interested in statistics at the state*year level, so I do not need to match individuals over time. Is there a way to weight data from combined these two supplements to yield representative state*year estimates? Thanks!

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Joe_Grover

Staff

Within each March and October sample, individuals are weighted to be nationally representative (using WTSUPP). Combining a single March and a single October sample and summarizing the data by year would result in a weighted population roughly twice the size of the actual U.S. population.

For your particular interests, looking at a State*Year analysis, I would recommend creating two datasets. One dataset with data from March Samples only summarized to the State*Year level using WTSUPP. Then create a separate dataset with data from October samples only summarized to the State*Year level using WTSUPP. This should result in two datasets, each with a single record foreach State Year combination (i.e. total number of Young Adults with Health Insurance in New York 1999 in one dataset, and total number of Young Adults Enrolled in School in New York 1999 in the second dataset). You could then merge these two datasets on State and Year to get State*Year summary data.

I hope this helps.

 

May 05, 2014 - 04:03 PM

1
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

How should I weight IPUMS-CPS data for representative HHINCOME statistics at ...
Matching CPS March supplement respondents longitudinally including monthly ba...
I am trying to calculate state by month unemployment rates for 2012,but March...
Are annual migration rates calculated from IPUMS CPS ASEC representative at t...
Login   |   Register

Recently Active Members

View More »

Share |