proc import 导入问题， 在线等。

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

把sheet="runlist"改成range="runlist$"

参考sas import读取数据介绍
http://wenku.baidu.com/link?url=_VNyW6O0LCqdG4cAX0hUOWfxj2eqCRiK6YMZtlMTGu-rkpAXOfIDbq3ZoNOCIOX5o6tnpjQRtN55DOceihNMPdIcwW7W0omOekh2KtLhDvO