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;
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;
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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.