Desktop productivity for business analysts and programmers

How to export a summary report into excel?

Reply
Occasional Contributor
Posts: 9

How to export a summary report into excel?

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

Contributor dkb
Contributor
Posts: 54

Re: How to export a summary report into excel?

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

Super User
Posts: 10,528

Re: How to export a summary report into excel?

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Occasional Contributor
Posts: 9

Re: How to export a summary report into excel?

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

Super User
Super User
Posts: 9,799

Re: How to export a summary report into excel?

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

Community Manager
Posts: 3,448

Re: How to export a summary report into excel?

Super User
Posts: 10,528

Re: How to export a summary report into excel?

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)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 6 replies
  • 786 views
  • 0 likes
  • 5 in conversation