Help on catx in proc sql update

[Mike_Davis]

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!

[Linlin]

try this:

%let y=abcdefg;

data one;

length x $ 20;

input x;

cards;

a

b

;

proc sql ;

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

quit;

proc print data=one;run;