How to increment as per another variable

[AravindPalanichamy]

Hi team,

I have a datasets like this

typeID	exclID
1	1001
1	1001
1	1001
1	1001
2	1001
2	1001
2	1001

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

[ballardw]

If the data is sorted by type ID

data want;

     set have;

     by typeId;

     if first.typeid then exclID = 1000*typeId;

     exclID + 1;

run;