topic Re: Way to export graph into Excel in ODS and Base Reporting

Way to export graph into Excel

shivamarrora0 — Thu, 05 Apr 2018 13:37:01 GMT

Hi all,

I want to export the graph PNG file to excde file

Thanks

Re: Way to export graph into Excel

PaigeMiller — Thu, 05 Apr 2018 14:00:31 GMT

Use ODS EXCEL

https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf

Re: Way to export graph into Excel

shivamarrora0 — Thu, 05 Apr 2018 16:51:09 GMT

This work on sas 9.4 but we have sas9.3
Is there any method for sas 9.3?

Re: Way to export graph into Excel

Cynthia_sas — Sat, 07 Apr 2018 22:56:14 GMT

Hi:
Yes, use ODS MSOFFICE2K which will make an HTML file. Then, you can open the HTML file using Excel. Excel has been able to open HTML files since Excel 97.

Or, you could see whether you can switch the report to ODS RTF or ODS PDF.

cynthia