Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: AW: RE: Re: re: counter variable


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: AW: RE: Re: re: counter variable
Date   Sat, 2 May 2009 19:43:40 +0200

<> 

Ok, so -encode-ing will be mandatory for Maryle now...

*************
clear
input str1 Id  byte (schlyr newprc)
A       1          1
A       2          0
A       3          0
A       4          0
A       5          0
A       6          0
A       7          0
A       8          0
A       9          0
A      10          0
A      11          0
B       1          1
B       2          0
B       3          0
B       4          0
B       5          0
B       6          0
B       7          0
B       8          0
B       9          0
B      10          1
B      11          0
end 

encode Id, gen(id)

capt ssc inst tsspell
tsset id schlyr

tsspell, fcond(newprc == 1)
list, noo sepby(id)
*************



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Nick Cox
Gesendet: Samstag, 2. Mai 2009 18:19
An: statalist@hsphsun2.harvard.edu
Betreff: st: RE: Re: re: counter variable

If the data have been -tsset id schlyr- and -tsspell- has been
downloaded from SSC then 

tsspell, fcond(newprinc == 1) 

is enough. This creates three new variables, of which _seq is the
counter desired. 

Nick 
n.j.cox@durham.ac.uk 

Martin Weiss

You have to hand it to all contributors here, though, that this is not
your 
everyday, apply-bysort-straightforwardly-and-look-at-Nick`s-column- 
in -the-SJ-carefully problem (see 
http://www.stata-journal.com/sjpdf.html?articlenum=pr0004). The fact
that 
you want this thing sorted, but not counted, by schoolyear and counted,
but 
not sorted, by the new dummy, makes this quite involved, and despite my
best 
effort, I cannot find a one liner for it that does not make extensive
use 
of -cond-. So kudos to Eva for her two liner :-)


"Kit Baum" <baum@bc.edu>

><> T suggested
>
>  g newvar = 1 if new_prc==1
>  bys Id (schlyr): replace newvar = newvar[_n-1]+1 if newvar !=1
>
> This sounds to me like a generally bad idea. The first statement just 
> changes the new_prc zero values into missing values. The second
statement 
> relies upon the fact that missing is a value not equal to 1.  Although
the 
> logic works, I think Eva's suggested approach is a better  way to
think 
> about a problem like this (although I deplore her  reliance on -set 
> varabbrev on-, which is IMHO a Very Bad Idea).

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



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index