版主peijiamei建议我将内容与博客链接都发上来，我很赞同。

将指定目录下的xls文件'd:\book1.xls'导入到work逻辑库中，建立名为accounts的临时数据集。 this program is： proc import datafile='d:\book1.xls'; /*use "proc import" to import file , here datafile='the file adress in computer category".*/ out=work.accounts /*out="where will you put the data file you import"*/ dbms=excel replace; /*dbms="the file's data base manegement system" , to xls file, it's always excel. replace means if the data set already exist , sas will overwrite it.*/ getnames=yes; /*whether you will get variables's name in the xls file , here we choose yes .*/ run;

博客原文地址：http://hi.baidu.com/_guobailing/blog/item/0952edd4cecaca289a5027d4.html