Date:         Wed, 6 Sep 2000 07:01:04 -0400
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: lagged values question

On Tue, 5 Sep 2000 18:12:24 GMT, Lan-Feng Tsai <lftsai@MY-DEJA.COM> wrote:

>Hi
>I have a question about lagged values.  Here is part of the data set.
>4 variables and 5 observations:
>
>pt      implant  visit94        visit95
>01      8-Mar-94 13-Mar-94      17-Oct-95
>01      8-Mar-94 11-Apr-94      17-Oct-95
>02      8-Mar-94 13-Mar-94      2-Jan-95
>02      8-Mar-94 3-May-94       11-Feb-95
>02      8-Mar-94 3-May-94       8-Oct-95
>
>And I am hoping the data will look like this
>
>pt      implant  visit94        visit95
>01      8-Mar-94 13-Mar-94      17-Oct-95
>                 11-Apr-94
>02      8-Mar-94 13-Mar-94      2-Jan-95
>                 3-May-94       11-Feb-95
>                                8-Oct-95
>
>This means that only one necessary value is shown for each patient,
>each variable.  The redundant records are set to be missing.
>
>Could someone tell me how to do that?  Thanks very much.
>
>Feng
>
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Are you really sure, that you want to become the origin DATA like that??
You might get some problems later with sorting, grouping and other
manipulations! Eg. you'll never find the record #2 for patient #01 after a
sort! You should keep the original data like they are and make reports,
e.g. with proc report or manipulate the data in a copy!