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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.