Date:         Tue, 23 Jan 2007 21:00:54 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: How to Check to non missing weight Units with in a Patient
Comments: To: "Subhu. Manyam" <proccontents@GMAIL.COM>

Given your example data, please show (the list) what the desired outcomes
should be for each of your two steps.

Art
--------
On Tue, 23 Jan 2007 19:55:02 -0600, SAS_learner <proccontents@GMAIL.COM>
wrote:

>Guys ,
>My data looks like this
>data test ;
> input pt fddt visddt wt wtu ;
>datalines;
>1001 01dec2006 01jan2006   74  2
> 1001 01dec2006 01feb2006   74
> 1001 01dec2006 01mar2006  74
>1002 01dec2006 01feb2006   74  1
> 1001 01dec2006 01feb2006   74
>
>My data is something like this I need to do two things
>1) Pick up wtu for the highest date with in a pt. If the wtu is missing
for
>that record  I need to pick up previous non missing wtu for that pt .
>2) After getting WTU populated I need to get the record with the highest
>fddt date .
>
>thanks for your time and suggestions