topic Lag Statement in SAS Data Management

Lag Statement

llt34c — Fri, 09 Sep 2016 16:25:24 GMT

I have a large data set that I am trying to use a lag statement that is nested within an if statement. I have attached a file that has the code and also an example of what the output looks like.

The lag statment is returning the previous weight and then using this weight to calculate a difference. The lag statment is nested within an if statement based on animal ID. If the previous ID doesn't match, a "." is returned. It is working with the exception of the 2nd observation. I know the first observation for each animal will be a ".". But the first two are ".". Any help is appreacited.

Thanks.

Re: Lag Statement

Astounding — Fri, 09 Sep 2016 16:41:42 GMT

LAG does not retrieve the value from the previous observation. That's a common mistake. LAG retrieves the value from the last time that LAG executed. So it becomes important (in most applications) to make sure that LAG executes on every observation.

The usual fix is to execute LAG on every observation by taking it out of any IF THEN statements. Then on the first observation for each animal ID, reset your new variable (the one that holds the results of the LAG function) to a missing value.

Re: Lag Statement

llt34c — Wed, 14 Sep 2016 16:43:29 GMT

Thanks for your reply.

I am struggeling on how to reset a variable to a missing value? I have never done this without using some type of if statement.

I appreciate your time.

Re: Lag Statement

Astounding — Wed, 14 Sep 2016 17:06:55 GMT

Yes, that's the right tool. Use an IF/THEN statement.

Re: Lag Statement

llt34c — Wed, 14 Sep 2016 17:22:20 GMT

Thank you so much!