BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Smitha9
Fluorite | Level 6

Hi,

I have a dataset a;

ID

003

004

006

 

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

 

dataset I want:

ID

20003

20004

20006

thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
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;

View solution in original post

1 REPLY 1
Reeza
Super User
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;