topic Re: ODS tagsets.excelxp GRAPHING not found. in ODS and Base Reporting

ODS tagsets.excelxp GRAPHING not found.

deleted_user — Wed, 21 Apr 2010 13:23:04 GMT

Has anyone been able to use the excelxp tagset to graph the data sets that proc print sends to excel? We're using an antiquated method to export reports to excel and the graph them and we're changing it to ODS. I'm at a loss to know why graphing is such an Achilles heel with the excelxp tagset. Especially given the simplicity of it.

Can anyone supply the code needed to create a simple bar chart in excel using tagsets.excelxp using the following data set?

data xyz;
x = 1;
y = 2;
z = 3;
run;

Many thanks to the person who can solve this.

Re: ODS tagsets.excelxp GRAPHING not found.

David_SAS — Wed, 21 Apr 2010 14:39:10 GMT

The ExcelXP tagset generates a Microsoft-defined XML called SpreadsheetML that is compatible with Excel 2003. SpreadsheetML does not support images.

-- David Kelley, SAS

Re: ODS tagsets.excelxp GRAPHING not found.

deleted_user — Wed, 21 Apr 2010 15:07:29 GMT

Whether it supports images is irrelevant. I just want to use Excel to graph the data in an automated fashion within a SAS command. The same way the tagset has commands to do formats, colors, column sizes etc. This is separate and distinct from exporting an image. In fact, even if Microsoft allowed for this, why would we even want to? The chart (image) would not even be interactive within excel.

I think what you're saying is that users can't use this tagset if they want to create graphs in excel. It just takes away so much of the functionality. I'm just going to return to proc export in that case. I mean, are these silly formatting issues really a concern when you can't even get an automated graph in place? I don't think users will care about row sizes and other simple formatting when they realize that at the end of the day the graphing facility is non-existent.
-Tony

Re: ODS tagsets.excelxp GRAPHING not found.

Peter_C — Mon, 26 Apr 2010 17:25:02 GMT

if first they "saveAs" a file-type that will suppoort graphs, then they will be able to create graphs. It won't be xml any more.

Re: ODS tagsets.excelxp GRAPHING not found.

gzr2mz39 — Mon, 26 Apr 2010 20:53:45 GMT

Have you tried the TableEditor tagset?
http://www2.sas.com/proceedings/forum2008/258-2008.pdf
See pg. 27.