Hi,
if you do not have any licenses for export to Excel you can create XML files that Excel can reads (with multiple sheets)
Basic information you can find on
http://support.sas.com/rnd/base/topics/odsmarkup/tableeditor/index.html
Remark: for a lot of data these files will be huge ! !
a quick example could be: ( you need the file tableeditor.tpl' that you can find in the URL mentioned above
=============================================================================
%include 'c:\temp\tableeditor.tpl';
ods tagsets.tableeditor file="c:\temp\export_naar_excel.html"
style=styles.mystyle
options(excel_zoom="90"
excel_scale="90"
excel_autofilter="yes"
excel_frozen_headers="yes"
excel_orientation="landscape"
sheet_name="first,second,third"
excel_table_move="1,2,3"
auto_format="color1"
excel_save_file="c:\\ temp.xls"
);
proc print data=sashelp.class;
run;
proc report data=sashelp.class nowd;
run;
proc print data=sashelp.orsales;
run;
ods tagsets.tableeditor close;
best regards,
Mark Roosen
... View more