topic Re: Assigning Same Numbers for Duplicate Records in SAS Procedures

Assigning Same Numbers for Duplicate Records

ScottyB_73 — Wed, 06 Jun 2012 14:05:03 GMT

Hi,

I have been tasked to assign the same numbers (not increments) for duplicate records. Here is an example of what I want to accomplish:

ID Code Number

A 1

B 2

C 3

D 4

E 5

F 6

G 7

Thanks!

MikeZdeb — Wed, 06 Jun 2012 14:09:39 GMT

hi ..., if data are sorted by IDCODE ...

data new;

set old;

by idcode;

number+first.idcode;

run;

ScottyB_73 — Wed, 06 Jun 2012 14:27:45 GMT

Thanks dude,

I didn't want to write 20+ if-then statements for each letter of the alphabet lol...

Ksharp — Thu, 07 Jun 2012 01:52:59 GMT

ScottyB_73 wrote:

Thanks dude,

I didn't want to write 20+ if-then statements for each letter of the alphabet lol...

In your sample data , there is only one variable idcode .

The same with Mike, Assuming you have sorted dataset by idcode.

data want;

set have;

if idcode ne lag(idcode) then number+1;

run;