# RE: st: RE: Hotdeck problem

 From "Rodrigo Alfaro A." <[email protected]> To <[email protected]>, <[email protected]> Subject RE: st: RE: Hotdeck problem Date Wed, 2 Apr 2008 09:21:48 -0400

```Joelle,

It worked for us. I cannot see the problem without the data, but you could try largering the by-set. For example, instead of using age, you could create a new variable that represents range of age, let's say x3=1 if age<=18 x3=2 if age>18 & age<=25. and so on.

Good luck, Rodrigo.

-----Mensaje original-----
De: [email protected] [mailto:[email protected]]
Enviado el: Mi�rcoles, 02 de Abril de 2008 09:11 a.m.
Para: [email protected]; Rodrigo Alfaro A.
Asunto: Re: st: RE: Hotdeck problem

Rodrigo,

Thank you for your response. I tried your suggested technique, and came up with the same results. The issue must lie within my variables...

Joelle

Quoting "Rodrigo Alfaro A." <[email protected]>:

> Joelle,
>
> It seems that you have missings in the by-variables. Consider the
> following sentence: hotdeck y, store by(x1 x2) keep(id). You will have
> troubles if x1 or x2 have missing, we "solved" the problem using the -9.
> Suppose x1 = {1, 2, 3} and x2={1, 2, 3, 4, 5}, then we created x1=-9
> if x1==. and x2=-9 if x2==., we hotdeck in that way (with the news x1
> and
> x2) and then we put as missings the cases where x1 or x2 ==-9. We did
> that with a simple loop.
>
> Rodrigo.
>
>
>
>
>
> -----Mensaje original-----
> De: [email protected]
> [mailto:[email protected]] En nombre de Joelle M
> Anderson Enviado el: Domingo, 30 de Marzo de 2008 01:38 p.m.
> Para: [email protected]
> Asunto: st: Hotdeck problem
>
> For my thesis, I am using the hotdeck program to impute values for
> missing cases in my income variable. Currently, I am trying to hotdeck
> my income variable (176 missing) using 3 variables (age=27 missing;
> education=13 missing; gender=0 missing; although with 9 overlapping
> missing values the combination of these three variables only has 31
> missing cases total). Yet when Stata creates my new, hotdecked income
> variable, there are an additional 19 missing cases that I can't
> account for (missing=50). Does anyone know why this might be? Another
> strange thing is that, when I try to rename my hotdecked income
> measure before merging it with my full dataset, all 50 missing cases
> remain missing after merging; when I do not rename my hotdecked income
> measure before merging, only 42 missing cases remain missing after
> merging. I have pasted my Stata output below. Any help would be greatly appreciated!
>
> Joelle Anderson
> Graduate Student, Sociology
> University of Wisconsin-Milwaukee
> [email protected]
>
> //First hotdeck imputation, renaming the income variable BEFORE
> merging with full dataset
>
> . hotdeck incomeR using IncomeHD, store by(education sex ageR)
> keep(resp
> incomeR)
> DELETING all matrices....
>
> Table of the Missing data patterns
>  * signifies missing and - is not missing
>
> Varlist order: incomeR
>
>     pattern |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>           * |        176       11.72       11.72
>           - |      1,326       88.28      100.00
> ------------+-----------------------------------
>       Total |      1,502      100.00
> WARNING: When the <command> option is not selected then no analysis is
> performed on the imputed datasets
>
>
> . use "C:\data\IncomeHD1.dta", clear
>
> . tab incomeR
>
>   RECODE of |
>      income |
>    (income. |
>  last year, |
>  that is in |
>  2004, what |
>    was your |
> total famil |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>           1 |        103        7.09        7.09
>           2 |        164       11.29       18.39
>           3 |        222       15.29       33.68
>           4 |        148       10.19       43.87
>           5 |        162       11.16       55.03
>           6 |        265       18.25       73.28
>           7 |        178       12.26       85.54
>           8 |        124        8.54       94.08
>           9 |         86        5.92      100.00
> ------------+-----------------------------------
>       Total |      1,452      100.00
>
> . rename incomeR incomez
>
> . merge resp using "C:\Documents and Settings\anders35\My
> Documents\Thesis_3_29.dta", unique sort
>
> . tab incomez
>
>   RECODE of |
>      income |
>    (income. |
>  last year, |
>  that is in |
>  2004, what |
>    was your |
> total famil |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>           1 |        103        7.09        7.09
>           2 |        164       11.29       18.39
>           3 |        222       15.29       33.68
>           4 |        148       10.19       43.87
>           5 |        162       11.16       55.03
>           6 |        265       18.25       73.28
>           7 |        178       12.26       85.54
>           8 |        124        8.54       94.08
>           9 |         86        5.92      100.00
> ------------+-----------------------------------
>       Total |      1,452      100.00
>
> //Second hotdeck imputation, renaming the hotdecked income variable
> AFTER merging with full dataset
>
> . hotdeck incomeR using IncomeHotD, store by(education sex ageR)
> keep(resp incomeR) DELETING all matrices....
>
> Table of the Missing data patterns
>  * signifies missing and - is not missing
>
> Varlist order: incomeR
>
>     pattern |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>           * |        176       11.72       11.72
>           - |      1,326       88.28      100.00
> ------------+-----------------------------------
>       Total |      1,502      100.00
> WARNING: When the <command> option is not selected then no analysis is
> performed on the imputed datasets
>
> . clear
>
> . use "C:\data\IncomeHotD1.dta", clear
>
> . tab incomeR
>
>   RECODE of |
>      income |
>    (income. |
>  last year, |
>  that is in |
>  2004, what |
>    was your |
> total famil |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>           1 |         98        6.75        6.75
>           2 |        162       11.16       17.91
>           3 |        220       15.15       33.06
>           4 |        153       10.54       43.60
>           5 |        159       10.95       54.55
>           6 |        267       18.39       72.93
>           7 |        178       12.26       85.19
>           8 |        126        8.68       93.87
>           9 |         89        6.13      100.00
> ------------+-----------------------------------
>       Total |      1,452      100.00
>
> . merge resp using "C:\Documents and Settings\anders35\My
> Documents\Thesis_3_29.dta", unique sort
>
> . rename incomeR incomey
>
> . tab incomey
>
>   RECODE of |
>      income |
>    (income. |
>  last year, |
>  that is in |
>  2004, what |
>    was your |
> total famil |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>           1 |         98        6.71        6.71
>           2 |        164       11.23       17.95
>           3 |        222       15.21       33.15
>           4 |        153       10.48       43.63
>           5 |        159       10.89       54.52
>           6 |        270       18.49       73.01
>           7 |        178       12.19       85.21
>           8 |        126        8.63       93.84
>           9 |         90        6.16      100.00
> ------------+-----------------------------------
>       Total |      1,460      100.00
>
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>
********************************************************************************
> ADVERTENCIA: La  informaci�n  contenida  en  esta  transmisi�n, y  en
> cualquier archivo  adjunto, est�  sujeta a reserva legal conforme a la
> normativa aplicable  al  Banco  Central  de  Chile, y  no  puede  ser
> usada o difundida  por personas distintas  de  su o sus destinatarios.
> Si usted ha recibido esta transmisi�n por error,  por  favor
> notifique  inmediatamente al remitente respondiendo por este mismo medio y elim�nela de su sistema.
> El  Banco Central de Chile no se har� responsable de la exactitud y
> veracidad de la informaci�n contenida en este mensaje, as�  como  de su  modificaci�n,
> copia, divulgaci�n  o  reenv�o,  total  o  parcial.   Su  uso  no  autorizado
> puede ser sancionado de conformidad con las leyes chilenas.
> El  Banco  Central  de  Chile  transmite  sus decisiones a trav�s de
> comunicados oficiales, los  que  pone  a  disposici�n  del p�blico en
> su p�gina de Internet: www.bcentral.cl
>
>
> DISCLAIMER: The information  contained  in  this  email or any
> attached file, is subject to legal  privilege  pursuant  to the laws
> and regulations applicable to the Central  Bank  of  Chile , and may
> not be used or disseminated by any person other  than  its  intended
> recipients. If you have received this transmission in error, please
> notify  the sender immediately by reply to this email address and delete it from your system.
> The Central Bank  of  Chile shall not be liable for the accuracy or
> authenticity of the contents of this message, whether amended, copied,
> forwarded or disclosed in  any  form, in  whole  or  in part.  Please
> note that unauthorized use may be penalized  in  conformity  with  the
> Chilean law.
> The Central  Bank of Chile communicates its decisions by  official
> releases, and makes them available to the public in its WebPages:
> www.bcentral.cl
>
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>

********************************************************************************
ADVERTENCIA: La  informaci�n  contenida  en  esta  transmisi�n, y  en  cualquier archivo  adjunto, est�  sujeta a reserva legal conforme a la normativa aplicable  al  Banco  Central  de  Chile, y  no  puede  ser usada o difundida  por personas distintas  de  su o sus destinatarios. Si usted ha recibido esta transmisi�n por error,  por  favor  notifique  inmediatamente al remitente respondiendo por este mismo medio y elim�nela de su sistema.
El  Banco Central de Chile no se har� responsable de la exactitud y veracidad de la informaci�n contenida en este mensaje, as�  como  de su  modificaci�n, copia, divulgaci�n  o  reenv�o,  total  o  parcial.   Su  uso  no  autorizado puede ser sancionado de conformidad con las leyes chilenas.
El  Banco  Central  de  Chile  transmite  sus decisiones a trav�s de comunicados oficiales, los  que  pone  a  disposici�n  del p�blico en su p�gina de Internet: www.bcentral.cl

DISCLAIMER: The information  contained  in  this  email or any attached file, is subject to legal  privilege  pursuant  to the laws and regulations applicable to the Central  Bank  of  Chile , and may not be used or disseminated by any person other  than  its  intended recipients. If you have received this transmission in error, please  notify  the sender immediately by reply to this email address and delete it from your system.
The Central Bank  of  Chile shall not be liable for the accuracy or authenticity of the contents of this message, whether amended, copied, forwarded or disclosed in  any  form, in  whole  or  in part.  Please note that unauthorized use may be penalized  in  conformity  with  the  Chilean law.
The Central  Bank of Chile communicates its decisions by  official releases, and
makes them available to the public in its WebPages: www.bcentral.cl

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```

• References: