SAS 导出文件

导出到excel

PROC EXPORT DATA=Work.myfile

OUTFILE=‘C:\temp\example.xls’

DBMS=EXCEL2000

REPLACE;

SHEET=‘My Sheet’;

RUN;

导出到Access

PROC EXPORT DATA=Work.myfile

OUTTABLE=‘My ACCESS Table’

DBMS=ACCESS2000 REPLACE;

DATABASE=‘C:\temp\mydatabase.mdb’

RUN;

分隔符文件

PROC EXPORT DATA=work.myfile

OUTFILE=‘C:\temp\myfile’

DBMS=DLM;

DELIMITER=‘/’;

RUN;

DBMS选项

DBMS=

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