SAS EG calculated column using lagged variable

Amber_Nicole94 — Wed, 25 Oct 2017 17:31:53 GMT

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.

Re: SAS EG calculated column using lagged variable

Reeza — Wed, 25 Oct 2017 17:38:29 GMT

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.

topic Re: SAS EG calculated column using lagged variable in SAS Programming

SAS EG calculated column using lagged variable

Re: SAS EG calculated column using lagged variable