Facing error while concatenating the columns

[vishalrajpoot3]

Please help me here as I am using below code I am getting multiple spaces within the ABC_clm. 

proc sql outobs=100;
create table test as
SELECT
C.CLM_ID,
C.CLM_VER_NBR,
cats('0000'||C.CLM_ID||(put(c.CLM_VER_NBR,z2.))) as ABC_clm
from NET.CLAIM C
where CLM_VER_NBR ne 0;
QUIT;

[UnknownCS]

The actual length of the CLM_ID column is longer than it is displayed. To resolve this, you can add strip function to remove the trailing blanks.

cats('0000'||strip(C.CLM_ID)||(put(c.CLM_VER_NBR,z2.))) as ABC_clm

[PaigeMiller]

Your syntax inside the CATS() function is incorrect. You want to use commas (not || ) to separate the different text strings to be concatenated.

cats('0000',C.CLM_ID,put(c.CLM_VER_NBR,z2.)) as ABC_clm