making an existing variable enumerate by 1

[Qpp1941]

Hello,

I have an id variable  (survey_unique_id) that, for some, does not  "increment by 1(up to 2056)" for a portion of observations. I want to keep the first observation "50001" and retain the vaue+1 for each observation that follows and continue this procedure until "52056".

I was able to create a new dataset just containing observations where "id" with 50001 only was available, without losing information of importance. 

Hope this is clear.

Thanks.

(Original dataset)

Example of what I had in mind for the variable (survey_unique_id) to look like.

5001

5002

5003

5004

5005

5006

5007

5008

5009

5010

etc...

[Reeza]

Just replace it with a new one?

Retain NEWID 5000;

NEWID+1;

[PGStats · Accepted solution]

50001 or 5001?

data want;
retain count 5001;
set have;
if id > 2056 then do;
  id = count;
  count = count + 1;
  end;
drop count;
run;

[Qpp1941]

it is 50001.