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
Tobit (if the values of dependent variable ranges between -6.96296 + 18.89634Tobit (if the values of dependent variable ranges between -6.96296 + 18.89634 what should be command…
Negative coefficient interpretationDear Researchers, What I know about the interpretation of the negative coefficient of the regression…
Fractional multinomial logit with fixed effectsHi, I have a panel data for 24 years. I want to see how state governments allocate total budget amon…
Converting standardized coefficients to percentage termsI am running a difference-in-difference regression. The treatment variable is assigned a continuum (…
Correcting for selectivity and omitted variable problems in discrete time event history analysisApologies for cross-listing. Dear all, I am trying to examine the effect of family ownership on th…
Subscribe to:
Post Comments (Atom)
0 Response to Creating per capita income from IPUMS ACS dataset across multiple years
Post a Comment