topic Re: Facing error while concatenating the columns in SAS Enterprise Guide

Facing error while concatenating the columns

vishalrajpoot3 — Mon, 06 Jan 2025 13:13:56 GMT

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;

Re: Facing error while concatenating the columns

UnknownCS — Mon, 06 Jan 2025 13:22:08 GMT

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

Re: Facing error while concatenating the columns

PaigeMiller — Mon, 06 Jan 2025 13:33:22 GMT

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