IF statement for Excel in EG

[HansSteenhuis]

Hello everyone,

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

NUMBER	CODE	IF statement
1410647	313
1410647	322	313
1411948	313
1411948	320	313
1411950	322
1411950	303	322
1412210	318
1412210	313	318
1412210	320	313
1412210	312	320
1598745	314
1598745	380	314
1598745	312	380
1598745	314	312
1598745	380	314
1598745	380	380
1598745	314	380
1598745	380	314

regards,

Hans

[jebjur]

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;