How can we do with retain statement creating sequence number?

rajeshalwayswel — Sun, 14 Jan 2018 22:50:23 GMT

In the below code I have created sequence number using first and last name in the sashelp.class I have distinct name so we get every record with 1 value in seq variable. Same i need in retain concept without using first and last.name.


data a;
set sashelp.class;
run;

data a1;
set a;
by name;
if first.name then seq=1;
else seq+1;
run;

Re: How can we do with retain statement creating sequence number?

novinosrin — Sun, 14 Jan 2018 22:58:06 GMT

Are you after the same results as you did, meaning all 1s

data a;
set sashelp.class;
run;

data a1;
set a;
retain seq 1;
if lag(name) eq name then seq+1;
run;

topic Re: How can we do with retain statement creating sequence number? in SAS Programming

How can we do with retain statement creating sequence number?

Re: How can we do with retain statement creating sequence number?