Hello
I have this data set;
data A;
input id admit;
cards;
001 2001
001 2002
001 2002
002 2001
002 2001
003 2002
;
run;
I wish to create data B from A
data B;
input id admit SeqN ;
cards;
001 2001 1
001 2002 2
001 2002 3
002 2001 1
002 2001 2
003 2002 1
;
run;
I want to create a SeqN from Data A.
As long as your data set is sorted by ID:
data want;
set have;
by id;
if first.id then SeqN=1;
else SeqN + 1;
run;
As long as your data set is sorted by ID:
data want;
set have;
by id;
if first.id then SeqN=1;
else SeqN + 1;
run;
Thank you!!!
Good use for ifn()?
data want; set have; by id; seqn=ifn(first.id,1,seqn+1); run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.