Date:         Fri, 9 Mar 2007 10:28:16 -0500
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: Last non-missing value

also replacing the condition by something like:

   if (htmc+wtkg+bmi+bsa) ne .;

(a subsetting IF in that case), could also be like:

   if (htmc+wtkg+bmi+bsa) = . then delete;

should do it.
Gerhard



On Fri, 9 Mar 2007 09:45:01 -0500, Rao Punnani <Rao.Punnani@RTP.PPDI.COM>
wrote:

>Hi sridhar,
>
>The following code might help , if I understood your problem correctly.
>
>Data new;
>infile datalines missover;
>        input subjnbr viscd htcm wtkg bmi bsa;
>                if viscd = 120 and (nmiss(htcm,wtkg,bmi,bsa)) > 0 then
>delete;
>        datalines;
>001 120 137 34.8 18.5 1.15
>001 120 136
>001 4080 138 35  19  1.21
>;
>
>Thanks,
>Rao.
>
>
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Sridhar, Nagakumar
>Sent: Thursday, March 08, 2007 4:36 PM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Re: Last non-missing value
>
>My apologies for not completing the information.  In the example given,
>I would have to get the first observation as baseline because I would
>have no missing values while in the second, I have the WTKG, BMI and BSA
>missing.
>
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Sridhar, Nagakumar
>Sent: Thursday, March 08, 2007 4:30 PM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Last non-missing value
>
>
>Hi All:
>
>        I have the following data:
>
>Data new;
>        input subjnbr viscd htcm wtkg bmi bsa;
>        cards;
>001 120 137 34.8 18.5 1.15
>001 120 136
>001 4080 138 35  19  1.21
>;
>
>I have to set the base line to the last non-missing value for
>viscd=120(there could be patients with 5 observations for the
>viscd=120).
>
>Any help in this regard would be greatly appreciated.
>
>TIA
>
>Kumar Sridhar
>
>*********************************************************************
>This message and any attachments are solely for the intended recipient.
>If you are not the intended recipient, disclosure, copying, use or
>distribution of the information included in this message is prohibited
>-- Please immediately and permanently delete.
>*********************************************************************
>This message and any attachments are solely for the intended recipient.
>If you are not the intended recipient, disclosure, copying, use or
>distribution of the information included in this message is prohibited
>-- Please immediately and permanently delete.
>
>
>______________________________________________________________________
>This email transmission and any documents, files or previous email
>messages attached to it may contain information that is confidential or
>legally privileged. If you are not the intended recipient or a person
>responsible for delivering this transmission to the intended recipient,
>you are hereby notified that you must not read this transmission and
>that any disclosure, copying, printing, distribution or use of this
>transmission is strictly prohibited. If you have received this
transmission
>in error, please immediately notify the sender by telephone or return
email
>and delete the original transmission and its attachments without reading
>or saving in any manner.