有安裝 SAS/ACCESS to PC Files 產品時
LIBNAME myxls EXCEL PATH='C: mpprdsale.xls';
LIBNAME myxls PCFILES SERVER=localhost PATH='C:prdsale.xls';
proc export dbms = excelcs data= sashelp.prdsale
outfile = "C:prdsale.xls "
replace;
server="localhost";
run;
proc export
data = sashelp.prdsale
dbms = excel
outfile = "c:prdsale.xls"
replace;
run;
proc export
data = sashelp.prdsale
dbms = xls
outfile = "c:prdsale.xls"
replace;
run;
proc export
data = sashelp.prdsale
dbms = xlsx
outfile = "c:prdsale.xlsx"
replace;
run;
若無 SAS/ACCESS to PC Files 安裝時
proc export
data = sashelp.prdsale
outfile = 'c: mpprdsle.csv'
dbms = csv
replace;
run;
此外,亦可使用下列方式產生 Excel 可讀取的檔案
-
ODS TAGSETS.CSV (http://support.sas.com/rnd/base/ods/excel/index.html)
-
ODS TAGSETS.EXCELXP (http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html)
-
FILENAME DDE (http://support.sas.com/documentation/cdl/en/hostwin/63047/HTML/default/viewer.htm#n1aqiv6biqkjbnn1gu1388hp7aab.htm
Tags