IF statement for Excel in EG

HansSteenhuis — Thu, 10 Sep 2020 12:10:14 GMT

Hello everyone,

Is it possible to apply this function that I have in Excel in EG?

regards,

Hans

Re: IF statement for Excel in EG

jebjur — Thu, 10 Sep 2020 17:12:45 GMT

I think you can use a combination of BY group processing and the LAG function to get the results you want.

proc sort data=one;
by number;
run;

data two;
set one;
by number;
y=lag(code);
if first.number then y=.;
run;