topic SEQUENTIAL NUMBER CREATION in SAS Programming

SEQUENTIAL NUMBER CREATION

scb — Fri, 27 Jan 2017 01:51:07 GMT

In the below dataset A, I have 4 names with ID numbers, may I know how to create new ID for the new names in dataset, from 1008 to 1011? Below is sample only, i could have thousands of new names.

DATA A;
INFILE CARDS;
INPUT ID NAME $;
CARDS;
1004 JESSICA
1005 UTAKA
1006 MORRISSON
1007 NELSON
;
RUN;

DATA B;
INFILE CARDS;
INPUT NAME $;
CARDS;
RYAN
HOLLY
MASON
DORREN
;
RUN;

Re: SEQUENTIAL NUMBER CREATION

Reeza — Fri, 27 Jan 2017 02:22:52 GMT

Are you using solely SAS? Many DBs have auto-incrementing IDs which is why I ask.

Re: SEQUENTIAL NUMBER CREATION

scb — Fri, 27 Jan 2017 02:25:24 GMT

Yes, SAS only.

Re: SEQUENTIAL NUMBER CREATION

Reeza — Fri, 27 Jan 2017 02:30:04 GMT

Data want;

set a(in=AI)

B(in=BI);

retain maxid count 0;

if AI and id>MaxID then maxID=ID;

if BI then Do;

count+1;

ID=maxID + count;

end;

run;

This can possibly be simplified massively but it's easy to understand.

Edit: fixed typo. Also, this is untested.