How to increment as per another variable

Reply
Occasional Contributor
Posts: 17

How to increment as per another variable

Hi team,

I have a datasets like this

typeIDexclID
11001
11001
11001
11001
21001
21001
21001

But i need to increment the exclID as per type ID for e.g, for typeID 1 it should increment like 1001, 1002, 1003, 1004

and for typeID 2 it should increment like from , 2001, 2002, 2003 like that.

It should increment depends on type ID.

and for typeID 3 it has to increment like 3001, 3002, 3003 and so on.

Please suggest a SAS program to implement this

Super User
Posts: 11,107

Re: How to increment as per another variable

If the data is sorted by type ID

data want;

     set have;

     by typeId;

     if first.typeid then exclID = 1000*typeId;

     exclID + 1;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 176 views
  • 0 likes
  • 2 in conversation