topic lag in SAS Programming

lag

Steelers_In_DC — Fri, 05 Dec 2014 15:35:02 GMT

I've attached a file with some code. I would like to get the equivalent to =B3+C3-D2-G2 in excel but my code is not performing the way that I want it too. I'm not sure if lag what I should be using here. Any help is appreciated.

Thank You,

Mark

Re: lag

ballardw — Fri, 05 Dec 2014 15:42:10 GMT

LAG has some pretty complex relationships with conditional execution.

You would be better to create a new variable such as Lpayment= lag(payment); BEFORE the IF not line of code and use Lpayment instead of lag(payment) within the calculation.

Re: lag

jakarman — Fri, 05 Dec 2014 16:33:22 GMT

do not confuse the queue function with the lag function.

There is no complexity when you understand that what SAS has implemented is a QUEUE http://en.wikipedia.org/wiki/Queue_(abstract_data_type) and has named that wrong as LAG http://msdn.microsoft.com/en-us/library/hh231256.aspx

Wrong naming can cause confusions, correct that and it will become easy.

Re: lag

Steelers_In_DC — Fri, 05 Dec 2014 17:19:07 GMT

Before the IF NOT line payment has no value, I'm putting it after the if not and after the payment = statement. That seems to get me the output I am looking for.