I'm working on ACS dataset which doesn't provide number of population in 50 states across different years. But, for each person the income is given.
I need to create per capita income from here and my best guess is by using egen command. Is it like the following
bysort statefip year: egen tot_inc = total(income)
bysort statefip year: egen tot_pop =total(statefip==?) [ I'm confused here since I don't know how to figure out the total population in ACS dataset for a particular state in a given year ]
gen per_cap_inc = tot_inc/tot_pop
I know how to figure out the per capita income for 50 states in multiple years , the thing is I'm having trouble how to find the total number of population in my dataset for a particular state in a given year ?
Please put your valuable input if you have any experience with IPUMS ACS data or you have a hunch on how to find total respondents from a particular state in. a given year from any dataset ?
Related Posts with Creating per capita income from IPUMS ACS dataset across multiple years
Stata command: ScalarHey Guys, i am a master's degree student in finance. For my master thesis i model the value at risk…
No result for F-test in fixed effects regression (clustered)Hi everyone, Stata does not display a F value for the following command. Unfortunately, I cannot di…
Combining datasets for yearly analysis with individual level observationsHi statalist, I'm trying to make a regressions analysis of variables X --> Y, I'm interested in …
Ommited variables fixed effects regressionHello all, I am a beginner in stata and using it for my bachelor thesis. Therefore my questions are…
Subtracting times across observations and applying weightsHello Everyone, I am new to STATA and would really appreciate your help with a problem I am stuck o…
Subscribe to:
Post Comments (Atom)
0 Response to Creating per capita income from IPUMS ACS dataset across multiple years
Post a Comment