topic Re: How to export a summary report into excel? in SAS Enterprise Guide

How to export a summary report into excel?

boey — Wed, 29 Apr 2015 03:33:48 GMT

If using "send to", i'm able to "send to excel" but how about export or export as a step in project?

Re: How to export a summary report into excel?

dkb — Wed, 29 Apr 2015 05:13:44 GMT

You can export the report as HTML and then open the HTML file in Excel.

Re: How to export a summary report into excel?

Kurt_Bremser — Wed, 29 Apr 2015 05:47:43 GMT

Or you go the whole way and use ODS tagsets.excelxp to create a .xml file containing the report, which can be opened by excel.

Re: How to export a summary report into excel?

boey — Thu, 21 May 2015 09:16:21 GMT

any other way which i can write coding so that the output can be exported automatically once i run the project?

Re: How to export a summary report into excel?

RW9 — Thu, 21 May 2015 10:01:54 GMT

KurtBremser has provided the answer, ods tagsets.excelxp is the (well, one of the) the ods destinations to create Excel files. So in your script do:

ods tagsets.excelxp file="abc.xml";

proc report....;

...;

run;

ods tagsets.excelxp close;

Base SAS: Demo: ExcelXP Tagset and Microsoft Excel

Re: How to export a summary report into excel?

Kurt_Bremser — Thu, 21 May 2015 10:11:16 GMT

Adding to what RW9 already stated, to help with further automation we would need to know specifics about your environment (single machine installation vs. client/server with Enterprise Guide, operating system of server, possible connections between server and client like Samba or Netware, and so on)

Re: How to export a summary report into excel?

ChrisHemedinger — Thu, 21 May 2015 12:30:58 GMT

ODS EXCEL (in SAS 9.4) is also an option:

http://blogs.sas.com/content/sasdummy/2014/08/29/experimenting-with-ods-excel-to-create-spreadsheets-from-sas/

Chris