Date:         Fri, 9 Mar 2007 09:45:01 -0500
Reply-To:     Rao Punnani <Rao.Punnani@RTP.PPDI.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Rao Punnani <Rao.Punnani@RTP.PPDI.COM>
Subject:      Re: Last non-missing value
Comments: To: "Sridhar, Nagakumar" <nagakumar.sridhar@SPCORP.COM>
In-Reply-To:  A<809BA36B4233FB4190D6D5A4C8BFA6610141DA92@KENMSG26.us.schp.com>
Content-Type: text/plain; charset="us-ascii"

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.