Add suffix based on a column of values

[NewUsrStat]

Hi, how can I add suffix to Ids based on a column?
Suppose to have:
Id suffix
0001 1
0001 1
0001 2
0002 2
0002 2
0002 1

Desired output
Id
0001_1
0001_1
0001_2
0002_2
0002_2
0002_1

Thank you in advance

[Kurt_Bremser · Accepted solution]

Most probably, you need to define a new variable (because of the length):

data want;
set have (rename=(id=_id)),
length id $6;
id = catx("_",_id,suffix);
drop _id suffix;
run;

[NewUsrStat]

Thank you dottor bremser. It works perfectly. Only one question: is it possible to convert back the modified ID to numeric?

[Kurt_Bremser]

I would not do that. Something that is not used for calculations, but for identification, is better kept as character.

[NewUsrStat]

ok thank you! It is just because there is a piece of code downstream that looks at it as numeric.