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

Change in CPS EMPSTAT (A-LFSR Labor force status recode) in 2001?
I have an extract 2001 to 2015. Total number of people: 4 million, but in bir...
Why are there fewer counties in the 1950 1% sample compared to the 1940 1% sa...
Is the value of INCWKCOM included in the value of INCDISAB?
Trying to access CPS online analysis tool
ACS METRO variable construction
Login   |   Register

Recently Active Members

View More »

Share |