see mvdecode, mvencode
or recode /replace
a.
----- Original Message -----
From: "Shabbar Jaffry" <[email protected]>
To: <[email protected]>
Sent: Monday, December 08, 2003 12:32 PM
Subject: st: Missing Data
> Dear Stata users,
>
> Currently I am working on a data set where I have to fill the gaps in the
data and then
> do analysis. An example of the data is as follows:
>
> id month sex empstatus
> 17 Feb-00 . .
> 17 Mar-00 . .
> 17 Apr-00 . .
> 17 May-00 . .
> 17 Jun-00 . 1
> 17 Jul-00 . 2
> 17 Aug-00 1 2
> 17 Sep-00 1 2
> 17 Oct-00 1 2
> 17 Nov-00 1 2
> 17 Dec-00 1 2
> 17 Jan-01 1 2
> 17 Feb-01 1 2
> 17 Mar-01 1 2
> 17 Apr-01 1 2
> 17 May-01 1 .
> 17 Jun-01 1 .
> 17 Jul-01 1 .
> 17 Aug-01 1 .
> 17 Sep-01 1 .
> 17 Oct-01 1 .
> 17 Nov-01 1 .
> 17 Dec-01 1 .
> 17 Jan-02 . .
> 17 Feb-02 . .
> 17 Mar-02 . .
> 17 Apr-02 . .
> 17 May-02 . .
> 17 Jun-02 . .
> 164 Mar-98 2 1
> 164 Apr-98 2 1
> 164 May-98 . .
> 164 Jun-98 2 1
> 502 Jul-98 1 .
> 502 Aug-98 1 .
> 502 Sep-98 1 2
> 502 Oct-98 . .
> 502 Nov-98 . .
> 502 Dec-98 . .
> 502 Jan-99 . 2
> 502 Feb-99 . 1
> 502 Mar-99 . 1
> 502 Apr-99 1 .
> 502 May-99 1 .
> 502 Jun-99 1 .
> 502 Jul-99 1 .
> 502 Aug-99 1 .
> 502 Sep-99 1 .
> 502 Oct-99 1 .
> 502 Nov-99 1 .
>
> where for sex 1 is coded for males and 2 for females and for employment
status
> (empstatus) 1 is employed and 2 for unemployed. Is there any fancy command
in stata
> which can fill the gaps.
>
> Yaseen
> University of Portsmouth
> UK
> *
> * 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/
*
* 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/
