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
Aggregation of pre-post treatment data (5 year intervals)I am trying to efficiently aggregate the IDA dollar (all_ida) amounts for the 5 year period before t…
marking ticks in the bar graphHi, Below is my graph that I used to generate the following graph. I want to add ticks to the middl…
PSM/Probit: 7 successes completely determined.Hi, I am doing propensity score matching and use the command psmatch2 in Stata 15.1. Below the tabl…
forvalues and xtile.Hello! I have a dataset with income and expense throughout several years (1992, 1994, ... 2016) I wa…
Job Posting for Biostatistician at Cancer Support CommunityEXECUTIVE SUMMARY The Cancer Support Community’s Research & Training Institute (RTI) in Philadel…
Subscribe to:
Post Comments (Atom)
0 Response to Creating per capita income from IPUMS ACS dataset across multiple years
Post a Comment