如何把excel中的数据导入<em>sas</em>中-sas excel数据导入,sas导入e

PROC IMPORT OUT= WORK.crackman
DATAFILE= "C:\Documents and Settings\Administrator\桌面\2008
.xls"
DBMS=EXCEL REPLACE;
RANGE="Sheet1$";
GETNAMES=YES;
MIXED=YES;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

proc import out=work.test
datafile="d:\yourtable.xls"
dbms=excel2000 repalce;
range="'sheet1'";
datarow=10;
getnames=yes;
run;
借鉴zd这个，根据你的excel版本专和sheet表名做属相应修改

proc import out=work.test
datafile="d:\yourtable.xls"
dbms=excel2000 repalce;
range="'sheet1'";
datarow=10;
getnames=yes;
run;