Date: Sat, 1 Sep 2007 17:07:54 -0400
Reply-To: Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Subject: Re: LOCF question still not resolved
In-Reply-To: <1188680164.543218.45810@d55g2000hsg.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
SASSQL,
I can not see how visit can take values (-1, 0). What are they? Do I miss ?
Muthia Kachirayan
On 9/1/07, sassql@gmail.com <sassql@gmail.com> wrote:
>
> On Sep 1, 4:54 pm, sas...@gmail.com wrote:
> > On Sep 1, 3:00 pm, sas...@gmail.com wrote:
> >
> >
> >
> > > Dear all,
> >
> > > Sorry to bother you guys again. But i have still LOCF issue
> > > unresolved. Let me describe the situation again. I really appreciate
> > > your help and time. Thanks again.
> >
> > > Hi,
> >
> > > Actually i have a data with around 100+ variables in it. And i need to
> > > make sure that there should be atleast 6 visits per patient. So if in
> > > case a patient is missing any visit, then i need to create a visit
> > > which is missing and then carry over the data from the previous visit
> > > for all the variables except few variables. I have two variables in
> > > the dataset named flag and ontreatment. So if a patient is missing any
> > > visit, i have to create a record for the missing visit, and carry over
> > > all the data from the previous visit for most of the variables, only
> > > where flag = 1 and ontreatment = 1.
> > > Example:
> >
> > > Patient visit FLAG ontreatment ecogscore OC_LOCF
> tumormeasurements
> > > investi
> > > 101
> -1 3 OC
> > > 20 ABC
> > > 101 0
> 2 OC
> > > 20 ABC
> > > 101 1 1 1 4
> > > OC 30 ABC
> > > 101 1 1
> 3 OC
> > > 30 ABC
> > > 101 2 1 1 4
> > > LOCF . ABC
> > > 101 3 1 1 2
> > > OC 34 ABC
> > > 101 4 1 1 2
> > > LOCF . ABC
> > > 101 5 1 1 2
> > > LOCF . ABC
> > > 101 6 1 1 2
> > > LOCF . ABC
> >
> > > So there are character and numeric variables both in the dataset whose
> > > value needs to be carry over. In the above example, for patient 101,
> > > its missing visit 2, 4 5 and6. So i have to carry over data from the
> > > visit 1 for visit 2 where flag = 1and ontreatment = 1 for all the
> > > variables except the tumormeasurements. For visit 4, 5 and 6, carry
> > > over the data from the visit 3 where flag = 1 and ontreatment = 1 for
> > > all variables except the tumor measurements. That's the reason the
> > > tumor measurements values are missing for the LOCF records.
> >
> > > I would really appreciate if you can let me know how i can implement
> > > the above LOCF. Just want to remind again that there are more than 100
> > > variables in the dataset and they are both character and numeric.
> >
> > > Thanks in advance.
> >
> > Dear all,
> >
> > Because the data wasnt aligned properly i have realigned it for easy
> > understanding.
> >
> > Dear I have realigned the data and i hope now it is easy to
> > understand.Sorry for the trouble.
> >
> > Patient visit FLAG ontrt ecog OC_LOCF tumor investi
> > 101 -1 . . 3 OC
> > 20 ABC
> > 101 0 . . 2 OC
> > 20 ABC
> > 101 1 1 1 4 OC
> > 30 ABC
> > 101 1 1 3 OC
> > 30 ABC
> > 101 2 1 1 4
> > LOCF . ABC
> > 101 3 1 1 2 OC
> > 34 ABC
> > 101 4 1 1 2
> > LOCF . ABC
> > 101 5 1 1 2
> > LOCF . ABC
> > 101 6 1 1 2
> > LOCF . ABC
> >
> > Regards,
>
> Dear all I dont know why the data is not realinging, but just for the
> understanding, the second row for each patient corresponds to the
> value for tumor and investigator. I hope that helps.
>
> Regards,
>
| 
