topic Re: making an existing variable enumerate by 1 in SAS Data Management

making an existing variable enumerate by 1

Qpp1941 — Wed, 19 Dec 2018 22:43:21 GMT

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...

Re: making an existing variable enumerate by 1

Reeza — Wed, 19 Dec 2018 23:02:41 GMT

Just replace it with a new one?

Retain NEWID 5000;

NEWID+1;

Re: making an existing variable enumerate by 1

PGStats — Wed, 19 Dec 2018 23:07:37 GMT

50001 or 5001?

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

Re: making an existing variable enumerate by 1

Qpp1941 — Wed, 19 Dec 2018 23:13:25 GMT

it is 50001.