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: 53

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: 7,419

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
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: 7,710

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: 2,889

Re: How to export a summary report into excel?

Super User
Posts: 7,419

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
Ask a Question
Discussion stats
  • 6 replies
  • 473 views
  • 0 likes
  • 5 in conversation