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
ThresholdsHi everyone I want to investigate from wich debt rate the labor productivity will start decreasing …
Meta analyse with STATA 15Hi, I have some problem with my new version of STATA 15, of course in the old versions it was very e…
** New On SSC ** censusapi - module to download census dataHi all Thanks to Kit Baum, censusapi is now available on SSC. This tool facilitates downloading dat…
Meaning of the Oaxaca_rif result?Thank you for your answer. The following results were obtained using oaxaca_rif. ------------------…
How to test pro-poorness of growth if the sample size in two surveys are not equalHi, I would like to test pro-poorness of growth. In the example “Testing for pro-poorness of growth …
Subscribe to:
Post Comments (Atom)
0 Response to monthly panel data; id average income, monthly average
Post a Comment