concatenate, add leading zeros

urban58 — Sat, 09 Jan 2021 00:51:09 GMT

Hello SAS community,

I have the following dataset and want to concatenate numeric variables type and id separated by a dash, I think my code below does that.

data have ;
input type id ;
cards;
1 2
1 55
2 100
3 99
4 4560
5 690
;
run;

data want; length id2 $ 6;
set have;
id2 = catx('-', type, id);
run;

I want id2 to have a length of 6 but not all ids have 4 digits, to compensate for that I would like to add leading "0"s so I get

I'm using SAS 9.4 on a PC.

I would appreciate any help!

Margaret

Re: concatenate, add leading zeros

Tom — Sat, 09 Jan 2021 01:09:10 GMT

Use the Z format to convert the numbers to strings with leading zeros.

id2 = catx('-', type, put(id,z4.) );

urban58 — Sat, 09 Jan 2021 02:17:03 GMT

Tom, thanks so much for the quick response - it works perfectly!