topic Add suffix based on a column of values in New SAS User

Add suffix based on a column of values

NewUsrStat — Sat, 01 Oct 2022 17:32:26 GMT

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

Re: Add suffix based on a column of values

Kurt_Bremser — Sat, 01 Oct 2022 21:30:58 GMT

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;

Re: Add suffix based on a column of values

NewUsrStat — Sun, 02 Oct 2022 09:46:07 GMT

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

Re: Add suffix based on a column of values

Kurt_Bremser — Sun, 02 Oct 2022 09:58:01 GMT

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

Re: Add suffix based on a column of values

NewUsrStat — Sun, 02 Oct 2022 10:14:42 GMT

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