java导出sas_[转载]SAS Proc Export导出文件

SAS 导出文件

导出到excel

PROC EXPORT DATA=Work.myfile

OUTFILE='C:tempexample.xls’

DBMS=EXCEL2000

REPLACE;

SHEET='My Sheet’;

RUN;

导出到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