BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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?
1 REPLY 1
Cynthia_sas
SAS Super FREQ
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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2070 views
  • 0 likes
  • 2 in conversation