DATA Step, Macro, Functions and more

how to create a sequence number

Accepted Solution Solved
Reply
Super Contributor
Posts: 303
Accepted Solution

how to create a sequence number

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.

 


Accepted Solutions
Solution
‎05-10-2017 10:52 PM
Super User
Posts: 5,498

Re: how to create a sequence number

Posted in reply to desireatem

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;

View solution in original post


All Replies
Solution
‎05-10-2017 10:52 PM
Super User
Posts: 5,498

Re: how to create a sequence number

Posted in reply to desireatem

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;

Super Contributor
Posts: 303

Re: how to create a sequence number

Posted in reply to Astounding

Thank you!!!

Super User
Super User
Posts: 7,942

Re: how to create a sequence number

Posted in reply to Astounding

Good use for ifn()?

data want;
  set have;
  by id;
  seqn=ifn(first.id,1,seqn+1);
run;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 148 views
  • 0 likes
  • 3 in conversation