Hey,
I have the following panel dataset;
monthly "total_income" dat of "hh_id" (households) from jan 2018 to dec 2020 ("mdate" as time variable) and I have problems calculating averages.
Btw, not all households are observed during the whole time period, like some are observed from feb 2019 to dec 2020.
They are also divided in 5 occupation classes "occupation_class" (categorical).
I want to have the following;
1.the monthly "total_income" average of all households, so what all the households earn on average during each month.
2. The same as above but separate for each "occupation_class".
I want to show these averages in tables but whatever I try I don't get good results.
I hope someone can help me
Related Posts with monthly panel data; id average income, monthly average
loop to append multiple files and add new variableHi there, I have a number of files named filename1990.dta, filename1991.dta etc until 2018. I would…
STATA: Statistic significance test within groups?Hi all, I am stuck at the following problem: I need to determine if there is a significant differenc…
Heckman Selection ProcedureHi Statalist, I have a quick question regarding exclusion restrictions when using Heckman Twostep. …
Convergence Not Achieved: after Running p-varHello guys, I am new to STATA. Now I am having problem. After running pvar, there are results, but…
xtreg, fe vs areg, & size of FE constantI have a panel of N = 3810 & T = 6, and after reading forum posts have run areg, absorb(company)…
Subscribe to:
Post Comments (Atom)
0 Response to monthly panel data; id average income, monthly average
Post a Comment