How to export a summary report into excel?

[boey]

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

[dkb]

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

[Kurt_Bremser]

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.

[boey]

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

[RW9]

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

[ChrisHemedinger]

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...

Chris

[Kurt_Bremser]

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)