Help on catx in proc sql update

Mike_Davis — Tue, 08 May 2012 19:54:12 GMT

Hello everyone.

I have problem when I run :

%let y=abcdefg;

proc sql noprint;

update one set x = catx('|',x,&y)

;

quit;

after U run the code:

:WARNING: Character expression will be truncated when assigned to character column x..

And In the result,the value of x is missing.

Please help.

Thanks!

Re: Help on catx in proc sql update

Linlin — Tue, 08 May 2012 20:07:37 GMT

try this:

%let y=abcdefg;

data one;

length x $ 20;

input x;

cards;

;

proc sql ;

update one set x = catx('|',x,"&y");

quit;

proc print data=one;run;