The SAS Output Delivery System and reporting techniques

Export SGPLOT result to Excel

New Contributor
Posts: 4

Export SGPLOT result to Excel

Dear All,

I have to copy and paste a lot from the RESULT panel to Excel, so I tried to output to Excel using the following:

ods tagsets.excelxp

file = '" hope graph is here "

style = minimal ;

proc sgplot data = mydata1;

series x = some_x  y =some_y


ods graphics off;

ods tagsets.excelxp close;

Here is the warning I get:

No default image type set in TAGSETS.EXCELXP. No graph will be generated for that destination.

So, where can I specify the "image type"?

Thank You So Much.

- Matt

Super User
Posts: 23,262

Re: Export SGPLOT result to Excel

ExcelXP does not allow images as far as I know.

HTML does or MSOffice2K_X.

Slide 11.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation