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