Exporting SAS/GRAPH into excel

deleted_user — Mon, 13 Dec 2010 13:10:18 GMT

Hi,

I am trying to export sas graphs to excel sheet by using ods and proc gplot.
when i ran the code, the graph is pasted into the excel but which is not visible at all(PNG format). BY default graph is pasted in some other location.

Can you please tell me the way to export graph to excel sheet?

Re: Exporting SAS/GRAPH into excel

Cynthia_sas — Mon, 13 Dec 2010 16:31:24 GMT

Hi,
It would be useful to see your ALL your code. When you use ODS, you are not directly doing an "export" of SAS/GRAPH output to Excel. ODS HTML (or other HTML-based destinations) are creating an ASCII text file with HTML tags, that Excel knows how to open and render.

Depending on the device driver you use (JPEG vs GIF vs ACTIVEX) in your DEVICE= option, Excel may treat your image in a different fashion when the HTML file is opened with Excel.

If you are using ODS TAGSETS.EXCELXP, you should see a note in the SAS log that says:
[pre]
Excel XML does not support output from Proc:Gchart
Output will not be created.
[/pre]

Can you share your code, including your options, goptions, ODS statements, etc??

cynthia

topic Exporting SAS/GRAPH into excel in Graphics Programming

Exporting SAS/GRAPH into excel

Re: Exporting SAS/GRAPH into excel