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