a*****3
发帖数: 601 | 1 一个很简单的sql into:语句，比如
proc sql;
select namelist into :longlist
from dataset1
having purchase = min(purchase);
quit;
问题1： 我这个longlist长度大概200~300，sas 报错如下：
Data too long for column "longlist";
truncated to 60 characters to fit.
问题2： 同时报第二个错如下：
NOTE: The query requires remerging summary statistics back with the original
data.
谁碰到过类似note？ |
a*****3
发帖数: 601 | 2 还有我印象里宏变量默认长度是256（？），怎么这个报错说截成60了？ |
s******y
发帖数: 352 | 3 1. I can not replicate the first the error with length set as 800.
data test;
length test $800;
test=repeat('a',800);
put test=;
run;
proc sql;
select test into :list from test;
quit;
%put >&list<;
2. it is not an error. you get the note, because the variable you select is
not in the GROUP by clause and aggregation functions.
【在 a*****3 的大作中提到】
: 还有我印象里宏变量默认长度是256（？），怎么这个报错说截成60了？
|
a*****3
发帖数: 601 | 4 感谢微笑男looking into the issue. 伪币30请查收 |
s******y
发帖数: 352 | 5 thanks. I will bet all the BAOZI for this week's NCAA game. if I win, we
will split.
【在 a*****3 的大作中提到】
: 感谢微笑男looking into the issue. 伪币30请查收
|
h*********y
发帖数: 183 | 6 宏变量长度好像有10000多字节，应该不止这么少 |
