topic Re: avoiding extra space when using CATQ in SAS Programming

avoiding extra space when using CATQ

Batman — Fri, 03 Jun 2022 19:23:01 GMT

How can I remove the space before the "n" in the variable y1.

data x;
y='Provider Name ';
y1=catq('1T',y,'n');
put y= y1=;
run;

Re: avoiding extra space when using CATQ

Kurt_Bremser — Fri, 03 Jun 2022 19:34:10 GMT

From the documentation of the CATQ function:

If you do not use the C, D, or H modifiers, CATQ uses a blank as a delimiter.

Re: avoiding extra space when using CATQ

data_null__ — Fri, 03 Jun 2022 19:36:58 GMT

Are you trying to make a name literal. There is a function for that.

45         data _null_;
46         y='Provider Name ';
47         y1=catq('1T',y,'n');
48         nl = nliteral(y);
49         put y= y1= nl=;
50         run;

y=Provider Name y1='Provider Name' n nl="Provider Name"N