topic Re: Lag function Basics in New SAS User

Lag function Basics

POOJA_J — Thu, 26 Oct 2023 14:41:53 GMT

I came across this MCQ.

The correct ans is B and even I read the logic behind this. But can anyone plz explain the same in more simple words. I didn't understand the logic explained in the image below.

Re: Lag function Basics

PaigeMiller — Thu, 26 Oct 2023 14:26:56 GMT

From now on, please post text and code as text and not as screen captures. From now on, please provide data as working SAS data step code.

Perhaps these words work better for you: https://communities.sas.com/t5/SAS-Programming/Unexpected-results-with-lag-function/m-p/820751#M324005

Basically, if you call LAG in an IF statement, and that branch of the IF statement doesn't execute, then the lagged value doesn't get created and thus the lagged value can't be used by the next observation.

Re: Lag function Basics

ballardw — Thu, 26 Oct 2023 14:29:00 GMT

LAG, and its companion function DIF, are queued functions. That means that when you use Lag inside of an IF, or related conditional code structure, that the "previous value" returned by the function is that the previous time that the IF was true.

So generally the preferred usage is to execute the Lag before any IF so you have the value as needed conditionally and typically drop the lagged variable unless needed later.

Re: Lag function Basics

POOJA_J — Thu, 26 Oct 2023 14:46:16 GMT

Thanks for explaining.
I will take care not to post screen shots next time.

Re: Lag function Basics

Tom — Thu, 26 Oct 2023 15:12:39 GMT

The real answer is (C) use the DIF() function instead.

tempdiff=dif(temp);