Export summary tables to excel
Export summary tables to excel
(OP)
Hi,
I've created several summary tables in SAS Enterprise Guide 4.2 and want to export all of the tables to Excel 2003. Is there a way to do this? I can export to HTML and open it with Excel, but I was hoping to simply run the process flow and automatically export into Excel. The only export file types I can export to are HTML, XML and PDF. Is this possible?
I've created several summary tables in SAS Enterprise Guide 4.2 and want to export all of the tables to Excel 2003. Is there a way to do this? I can export to HTML and open it with Excel, but I was hoping to simply run the process flow and automatically export into Excel. The only export file types I can export to are HTML, XML and PDF. Is this possible?
RE: Export summary tables to excel
What is SAS actually running on? Are you remote submitting code to a Unix system via EG? You should just be able to right click on the data, select "Send To" and then "Microsoft Excel". If you can't do that, then it's likely your SAS Server doesn't have that module installed (likely it's a Unix server).
In that case, I recommend using a tagset and proc print.
CODE
options(absolute_column_width='10,10,10,10,8,8,8,8,8,8,8,8,8,8'
row_repeat='header'
embedded_titles='yes'
frozen_headers='yes'
scale='100'
orientation='landscape'
sheet_name='Report'
)
style=styles.psexcel;
proc print data=dset noobs;
run;
ods tagsets.excelxp close;
Lower than that, you'll have to just output to a CSV file or something.
Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.