Question

Status:Closed    Asked:Apr 06, 2017 - 04:12 PM

How to aggregate IPUMS USA microfata to PUMA

I downloaded a IPUMS ACS microdata extract (2006-2015) and generated a number of binary variables from the data. I want to generate counts of these binary variables by year and PUMA (e.x. how many males? how many veterans?). I know there are other ways to do this (DataFerrett and ACS FactFinder), but other methods involve a lot more iterative downloading/room for human error. How do I generate counts by the PUMA level? I can give more info (about what statistical package I am using/code I am running) if needed.

 
Do you have the same question? Follow this Question
 

Answers

Did you download the PUMA variable so you have that in each row? If not, go back and revise so that you have the PUMA variable, then you can do a pivot table in Excel or other program to create summed totals of each variable that you want.

 

Apr 06, 2017 - 04:14 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

zero wages
Sample weights
tehre is information about the size of the firm in the Census/ASEC datasets?
Sample selection for a study of a subgroup over time?
Is it possible to get information on municipality or district of respondent i...
Weekly earnings and usual hours
Login   |   Register

Recently Active Members

View More »

Share |