Hi,
I try to do this code:
proc sql;
update WORK.List
set New= catx('-', put(substr(New, 7, 4), $4.), put(datepart(Date), yymmdd10.), Name)
, Name=case when Name LIKE '%NOVA' then substr(Name, 1, length(Name)-4) end
;
I have this error:
In a call to the CATX function, the buffer allocated for the result was not long enough to contain the concatenation of
all the arguments. The correct result would contain 30 characters, but the actual result might either be truncated to 16
character(s) or be completely blank, depending on the calling environment. The following note indicates the left-most
argument that caused truncation.
WARNING: In a call to the CATX function, the buffer allocated for the result was not long enough to contain the concatenation of
2 The SAS System 14:03 Friday, March 16, 2018
all the arguments. The correct result would contain 35 characters, but the actual result might either be truncated to 16
character(s) or be completely blank, depending on the calling environment. The following note indicates the left-most
argument that caused truncation.
The result is a column in blanks, not the string truncated to 16, i don't understand what means calling environment to be completely blank.
I try to change length in proc sql like:
t1.New format=$100., but always same error. I think is because de limitation of buffer in catx.
How i can solve this problem?
Regards,
Aleixo
... View more
