I will consider using the CATX method provided by SAS. It automatically takes care of trailing space but assigns 200 bytes of space to the new variable. For that, users can use the LENGTH method to use a certain space. Syntax -- CATX(' delimiter ', first_var, second_var, ....and more). Another method --> This is a little bit long but gives the same result using TRIM and ' || '. Syntax -- TRIM(first_var) || ' delimiter ' || TRIM(second_var) || ' delimiter ' || ......and more.
... View more