topic Changing ID of observations in SAS Programming

Changing ID of observations

Job04 — Thu, 03 Mar 2022 07:49:18 GMT

I have dataset with patients' IDs numbered in no sequential way. I want to make change to all the IDs.

For example patient 002 would be after the change: F1-1-KIDN-002.

It is just adding "F1-1-KIDN-" in front of the original ID.

I give an example of how the data looks like.

Thank you

id,C1,C2,C3,C4
002,4.19855,5.74574,33.46678,6.85391
007,3.48004,6.69138,31.85662,11.73753
009,3.33851,5.74293,36.09064,10.9801
020,3.2966,8.15718,30.27008,7.62836

Re: Changing ID of observations

Kurt_Bremser — Thu, 03 Mar 2022 08:02:34 GMT

Is id currently stored as numeric or character?

Posting example data in a data step with datalines would have made this question unnecessary.

Re: Changing ID of observations

Job04 — Thu, 03 Mar 2022 08:05:08 GMT

Numeric

Re: Changing ID of observations

Kurt_Bremser — Thu, 03 Mar 2022 08:34:23 GMT

data want;
set have (rename=(id=_id));
length id $13;
id = "F1-1-KIDN-" !! put(_id,z3.);
drop _id;
run;