Date:         Fri, 22 May 2009 17:35:29 -0400
Reply-To:     Randy <randistan69@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Randy <randistan69@HOTMAIL.COM>
Subject:      Lead Function

Dear All:
  Is there a lead function in SAS 9.1.  I could not find it in Documentation.
Perhaps you guys can help me with my question.  The data set is as follows:

VarA    Time
A        11:31
A        11:32
A        11:33
A        11:35
B        11:36
A        11:40
A        11:51
A        11:52
B        11:53
B        11:54
B        11:55
A        11:57

The dataset that I want with the lead time with one condition.  Two lags
before a B takes the time of the last B in the group.  So in the case of the
first B the var Lead_time (third row) takes a value of 11:36 (the value of
the last B in that group).  Similarly, the lead_time value in row 7 takes
the value of the last B value (11:55) in the forward group

VarA    Time          Lead_time
A        11:31         11:32
A        11:32         11:33
A        11:33         11:36
A        11:35         11:36
B        11:36         11:40
A        11:40         11:51
A        11:51         11:55
A        11:52         11:53
B        11:53         11:54
B        11:54         11:55
B        11:55         11:57
A        11:57         .

Can you please help.