方法之一,其他方法详见sas官网案例
Import-Only Methodology
You can save your Excel worksheet as a tab-delimited file and then import that file into SAS, as follows:
1.In your Excel worksheet, select File ► Save As ► Other Formats.
2.Then select Text (Tab Delimited) from the Save As type list. The application prompts you with a message that it will only save the current sheet as this type.
3.You can then submit the following procedure to import your file:
proc import datafile='your-files.txt' out=test dbms=tab;
run;