RE: st: RE: stata generated wrong lagged values for mi data

["Martin Weiss" <martin.weiss1@gmx.de>]

<>

I am not much of an -mi- guy, but did my very best in my effort to recreate
the conditions that you seemed to experience on your end. So I tried to use
-mi tsset- as in your code, and that only works with -mi set- present. Also,
I had to -gen- the time variable which obviously you do not need to do...


HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of
jl591164@albany.edu
Sent: Donnerstag, 3. Juni 2010 19:17
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: RE: stata generated wrong lagged values for mi data

The one-time lagged x is not picking up the values of x at time-1. As
showed below.
ID _mi_m time x lagx
 1   0     0  0  .
 1   0     1  0  0
 1   0     2  2  1
 1   0     3  1  1
 1   0     4  0  0
 1   1     0  0  .
 1   1     1  0  0
 1   1     2  0  1
 1   1     3  0  1
 1   1     4  1  0

I have five multiple imputed datasets. Could the multiple imputed data
cause the problem? I used colon after by id and it gives the same wrong
lagged values. Martin's syntex is quite differnt from mine. What is the
purpose of mi set wide? As my syntax shows, i did not do gen time=_n
either. Which part of your syntex is the core piece that i should follow
exactlly? Thanks.

 BTW, Junqing, listers would certainly like to hear from you how the lagged
> values are "wrong". It could mean different things to different people, so
> you should give an example of what it is that bothers you about them. In
> my
> example, everything seems normal:
>
> ***
> clear*
> set obs 100
> //id
> gen id=_n
> //expand to # of time periods
> expand 10
> bys id: gen time=_n
> gen x=rnormal()
> compress
> mi set wide
> mi tsset id time
> by id: gen lagx=l.x
> l in 1/50, sepby(id)
> ***
>
>
> HTH
> Martin
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of
> jl591164@albany.edu
> Sent: Mittwoch, 2. Juni 2010 23:43
> To: statalist@hsphsun2.harvard.edu
> Subject: st: stata generated wrong lagged values for mi data
>
> My data is panel data in mi format. I used the following syntax to
> generate several lagged varaibles(one time point lag) one by one:
>
> mi tsset ID time
> sort ID time
> by ID, gen lagx=l.x
>
> But i found that the generaged lagged values of panels were wrong. How i
> may fix it? Thanks a lot.
>
> Junqing
>
>
> *
> *   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/
>

*
*   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/