Export SGPLOT result to Excel

[Matt_Lin]

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

[Reeza]

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.