[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Logic help
From:       Ya Huang <ya.huang () AMYLIN ! COM>
Date:       2008-04-30 23:24:23
Message-ID: 200804302324.m3UHbMi8015241 () malibu ! cc ! uga ! edu
[Download RAW message or body]

You are very close:

data want;
     set have (where=(var2=0)) end=last;
  if last then output;
run;

On Wed, 30 Apr 2008 19:15:23 -0400, DP <adsingh78@GMAIL.COM> wrote:

>Hi,
>
>How to get the maximum event time (MAXEVETM) that should be the last value
>of VAR1 where VAR2=0.
>
>Have:
>VAR1 VAR2
>8 0
>8 0
>8 1
>8 0
>8 1
>9 0
>9 0
>9 0
>9 1
>10 0
>11      1
>
>Want:
>
>VAR1 VAR2  MAXEVETM
>10   0          10
>
>Can it be done without sorting the data?
>
>I have this but not sure if correct…
>
>data want;
>     set have end=last;
>  if last and CENSOR=0 then output;
>run;
>
>Thanks a lot!
>
>DP
[prev in list] [next in list] [prev in thread] [next in thread]