Correct. I guess the -egen- should just select those cases.
. bysort whateverisyourid : gen multiple = _N > 1
. egen id = group(whateverisyourid) if multiple
. bysort id (entrytime):
replace somevar = . if _n == 1 & mod(id,5) == 0
Nick
[email protected]
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Keith Dear
> Sent: 04 November 2004 01:36
> To: [email protected]
> Subject: Re: st: RE: Creating missing data
>
>
> But celdjt said he wanted to do this for every fifth
> *multiple-record*
> case. He could first drop the single-record cases, apply
> Nick's code, then
> append them back. Or is there a neater way?
> kd
>
> At 12:18 PM 4/11/04, you wrote:
> >Suppose your identifiers run 1, 2, ... . If this isn't true,
> >
> >. egen id = group(whateverisyourid)
> >
> >will make it so.
> >
> >Now, if I understand you correctly, you want to
> >
> >. bysort id (entrytime):
> > replace somevar = . if _n == 1 & mod(id,5) == 0
> >
> >Nick
> >[email protected]
> >
> >[email protected]
> >
> > > My
> > > question is about making an adjustment to the surrogate
> data set. The
> > > surrogate data set contains about 3500 cases, some of which
> > > have just one
> > > record per case, and others have multiple records. Each
> record has a
> > > variable recording an entering time and an exit time for
> that record.
> > > Hence, single record cases have one entry time and one exit
> > > time; multiple
> > > record cases have multiple entry and multiple exit times. I
> > > would like to
> > > convert the first entry time for every fifth multiple-record
> > > case in this
> > > data set into a missing value. Are there any suggestions for
> > > how this might be done.
> >
> >*
> >* 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/
>
>
> ==========================================================
> Dr Keith B.G. Dear
> Senior Fellow
> * Centre for Mental Health Research (CMHR)
> * National Centre for Epidemiology and Popn Health (NCEPH)
>
> The Australian National University
> Canberra ACT 0200 Australia
> T: +61 2 6125 4865 (NCEPH)
> T: +61 2 6125 8439 (CMHR)
> F: +61 2 6125 0740
>
> CRICOS Provider #00120C
> http://nceph.anu.edu.au/Staff_Students/staff_pages/dear.php
>
> *
> * 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/
