The SAS Output Delivery System and reporting techniques

Export SGPLOT result to Excel

Reply
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

run;

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

Grand Advisor
Posts: 17,338

Re: Export SGPLOT result to Excel

ExcelXP does not allow images as far as I know.

HTML does or MSOffice2K_X.

http://www.mwsug.org/proceedings/2010/excel_db/MWSUG-2010-113.pdf

Slide 11.

Ask a Question
Discussion stats
  • 1 reply
  • 1197 views
  • 0 likes
  • 2 in conversation