Good day all
I am using a stacked cross-sectional dataset, called the South African Post-Apartheid Labour Market Series (PALMS), from the years 1993 to 2017.
There is a lot of missing data for the monthly earnings variable. Therefore, I have been requested to figure out how to go about doing a cell mean imputation for item non-response on missing earning figures. This is apparently done by calculating the cell mean of earnings for all those who have the same education (coded to be if they have less than 12 years of schooling, have 12 years or more than 12 years) and belong to the same population group; and then giving those in the same groups with missing earnings this cell mean.
I do not know how to go about doing this. I would understand i could use a loop for the respective years, but I am at a loss with calculating the cell means and imputing them.
Would anyone be able to help?
Regards
Related Posts with Cell Mean Imputation
Using mata to create matrixI'd like to create a matrix shown in the figure. It's a NC*(N+C) matrix. All N block matrixes on the…
Using margins with several related continuous variablesI performed a Poisson regression with robust variance estimation. I have 3 independent variables. Th…
How to graph difference in means between model 1 and model 2Hi Statalist, I will appreciate help with this problem. First, here is my data: Code: * Example g…
Long Data Format: Creating a New Variable with Values Conditional on Combination of Values of Other Variables Across Many ObservationsHello! I am stuck not knowing how to create a variable I need based on my current data. I have a l…
total dose per day with multiple dates and times Code: * Example generated by -dataex-. To install: ssc install dataex clear input int(date_daily_3…
Subscribe to:
Post Comments (Atom)
0 Response to Cell Mean Imputation
Post a Comment