10-25-2017 01:31 PM
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.
10-25-2017 01:38 PM
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.