Value from a precedent row

[SASdevAnneMarie]

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]

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

Mind showing what you’ve tried?

[FreelanceReinh · Accepted solution]

Hello  @SASdevAnneMarie,

---

@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]

Thank you !