DATA Step, Macro, Functions and more

SAS EG calculated column using lagged variable

Reply
Contributor
Posts: 28

SAS EG calculated column using lagged variable

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.

 

Super User
Posts: 23,928

Re: SAS EG calculated column using lagged variable

Posted in reply to Amber_Nicole94

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.

Ask a Question
Discussion stats
  • 1 reply
  • 103 views
  • 0 likes
  • 2 in conversation