SAS EG calculated column using lagged variable

[Amber_Nicole94]

I am using SAS EG and attempting to use the lag function however it is telling me

"ERROR: The LAG function is not supported in PROC SQL, it is only valid within the DATA step." I have sorted the data by the fields I am trying to lag.

The goal is within my dataset, I want to create a dummy variable for if a condition is met. Example, if track = last line track AND driver = last line driver AND date equals last line date THEN indicate using a 1, else use a zero.

I do all of this using the query builder and creating calculated columns.

[Reeza]

Well...the error is correct, SQL doesn't have the concept of row order, it operates on the entire data set. 

What are you trying to do here? I suspect BY group processing within a data set is more efficient.