sas运行如下程序:
PROC IMPORT OUT= WORK.aCG_Director
DATAFILE= "E:\第二次整理\ceo\CG_Director.xls"
DBMS=EXCEL REPLACE;
RANGE="CG_Director$";
GETNAMES=YES;
MIXED=YES;
TEXTSIZE=32766;
USEDATE=YES;
RUN;
提示
NOTE: Data source is connected in READ ONLY mode.
WARNING: Failed to scan text length or time type for column D0801c.
NOTE: 成功创建“WORK.ACG_DIRECTOR”数据集。
NOTE: “PROCEDURE IMPORT”所用时间(总处理时间):
实际时间 8.04 秒
CPU 时间 5.79 秒
为什么会提示
WARNING: Failed to scan text length or time type for column D0801c?
如何消除这一问题?
查看数据后发现D0801c为截断数据,