Re: st: how to fill some gross wage missings if I have the net wage

["Laura R." <laura.roh@googlemail.com>]

Dear Austin,

that sounds like a good point to start with, thank you very much.
However, I see that after imputing the value, one has to use the -mi
estimate- command for models, however, I would like to estimate some
other models with panel data instead.

I came up with the following solution: just make a regression on gross
wage with several independent variables with the cases that report
gross wage, and then calculate the gross wage for the others using the
b coefficients and the independent variables. Would that work as well?

Laura





2010/12/15 Austin Nichols <austinnichols@gmail.com>:
> Laura R. <laura.roh@googlemail.com>:
> More institutional detail is required for a good answer--net of what?
> Taxes (federal/state/payroll--employee and employer), tax-deferred or
> tax-exempt contributions (health insurance premiums? pension
> contributions? including employer components?), union dues, other
> deductions, etc.? That said, you can validate a regression model for
> imputation by first restricting your attention to the 30% and
> artificially making half (or more) missing, then imputing those "fake
> missings" using official -mi- or -ice- on SSC, and checking your
> results against the unaltered data.  Once you're comfortable with your
> model, take it back to the full dataset.  I would start with a linear
> spline in gross wage, i.e. categories and linear terms; see also -help
> mkspline-.  Also read:
> http://www.stata.com/support/faqs/stat/mi_ice.html
>
> On Wed, Dec 15, 2010 at 10:10 AM, Laura R. <laura.roh@googlemail.com> wrote:
>> for some reason, I would like to use the gross wage for my estimations. However,
>> - only 30% of respondents have given both net and gross wage, while
>> - 70% of respondents have only given their net wage.
>> These data are all from the same country and therefore underlying the
>> same tax laws. So on the basis those who gave both gross and net wage
>> and with the help of the net wage of those where the gross wage is
>> missing, can I impute the missing gross wages? If so, how could I
>> implement this in Stata?
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/