topic Re: Add digits to the value in New SAS User

Add digits to the value

Smitha9 — Tue, 16 Mar 2021 16:17:28 GMT

Hi,

I have a dataset a;

003

004

006

I want to add "20" in front of these values.

dataset I want:

20003

20004

20006

thank you

Re: Add digits to the value

Reeza — Tue, 16 Mar 2021 16:21:10 GMT

Is it a character or numeric variable?
Assuming it's character since you have leading zeros, then you can use the CAT() and CAT_() family of functions.

data want;
set have;

NEW_ID = catt("20", OLD_ID);

run;