How to increment as per another variable

AravindPalanichamy — Wed, 22 Oct 2014 21:58:26 GMT

Hi team,

I have a datasets like this

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

Re: How to increment as per another variable

ballardw — Wed, 22 Oct 2014 22:55:34 GMT

If the data is sorted by type ID

data want;

set have;

by typeId;

if first.typeid then exclID = 1000*typeId;

exclID + 1;

run;