Export SGPLOT result to Excel

Matt_Lin — Wed, 19 Jun 2013 17:33:44 GMT

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

Re: Export SGPLOT result to Excel

Reeza — Wed, 19 Jun 2013 17:37:53 GMT

ExcelXP does not allow images as far as I know.

HTML does or MSOffice2K_X.

Slide 11.