topic Value from a precedent row in SAS Programming

Value from a precedent row

SASdevAnneMarie — Sun, 10 Mar 2024 18:53:20 GMT

Hello Experts,

I'm wondering how to take the value from a precedent raw. The lag function doesn't work.

I have joined the data.

Thank you very much for your help.

Mazi — Sun, 10 Mar 2024 18:59:54 GMT

Could you elaborate, what do you mean when you say the lag function does not work?

Mind showing what you’ve tried?

FreelanceReinh — Sun, 10 Mar 2024 19:05:47 GMT

@SASdevAnneMarie wrote:

The lag function doesn't work.

I guess you mean that values are carried over from one BY group to the next. But this can be avoided:

data want;
set have;
by numero code2;
MT2_CORR_befor=ifn(first.code2,.,lag(MT_2_CORR));
run;

SASdevAnneMarie — Sun, 10 Mar 2024 19:11:05 GMT

Thank you !