SAS 導(dǎo)出文件

導(dǎo)出到excel

PROC EXPORT DATA=Work.myfile

OUTFILE='C:tempexample.xls’

DBMS=EXCEL2000

REPLACE;

SHEET='My Sheet’;

RUN;

導(dǎo)出到Access

PROC EXPORT DATA=Work.myfile

OUTTABLE='My ACCESS Table’

DBMS=ACCESS2000 REPLACE;

DATABASE='C:tempmydatabase.mdb’

RUN;

分隔符文件

PROC EXPORT DATA=work.myfile

OUTFILE='C:tempmyfile’

DBMS=DLM;

DELIMITER='/’;

RUN;

DBMS選項

DBMS=

Can be ACCESS97, ACCESS2000, ACCESS2002, ACCESSCS, CSV, DBF, EXCEL4, EXCEL5, EXCEL97, EXCEL2000,JMP, PCFS, TAB, WK1, WK3, WK4