proc import 导入问题，在线等。 [推广有奖]

1关注
0粉丝

已卖：23份资源

初中生

28%

还不是VIP/贵宾

-

0%

威望: 0 级
论坛币: 80 个
通用积分: 3.1548
学术水平: 0 点
热心指数: 0 点
信用等级: 0 点
经验: 1107 点
帖子: 10
精华: 0
在线时间: 17 小时
注册时间: 2010-4-20
最后登录: 2014-5-30

楼主

wujiyan99

发表于 2014-4-28 10:32:05 |AI写论文

3论坛币

EXCEL 格式：

Product_family	parm	bin_type	bin	side	ucl	maxy	tick_spacing
bbbb	mean	ccc	Large	A	25	50	5
aaaa	mean	vvv	Large	A	20	50	5

程序： SAS 9.2
proc import out=runlist replace    datafile="C:\ftp_candela_control_file.xls"
DBMS=EXCEL REPLACE;
getnames=yes;
mixed=yes;
sheet="runlist";
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES; run;

log :

The SAS System
NOTE: Data source is connected in READ ONLY mode.
WARNING: Failed to scan text length or time type for column Product_family.
WARNING: Failed to scan text length or time type for column parm.
WARNING: Failed to scan text length or time type for column bin_type.
WARNING: Failed to scan text length or time type for column bin.
WARNING: Failed to scan text length or time type for column side.
ERROR: Open cursor: Selected collating sequence not supported by the operating system.
ERROR: Import unsuccessful.  See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
   real time          1.53 seconds
   cpu time          0.57 seconds