The SAS Output Delivery System and reporting techniques

ODS tagsets.excelxp GRAPHING not found.

Reply
N/A
Posts: 0

ODS tagsets.excelxp GRAPHING not found.

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.
SAS Employee
Posts: 174

Re: ODS tagsets.excelxp GRAPHING not found.

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

-- David Kelley, SAS
N/A
Posts: 0

Re: ODS tagsets.excelxp GRAPHING not found.

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
Valued Guide
Posts: 2,175

Re: ODS tagsets.excelxp GRAPHING not found.

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.
Regular Contributor
Posts: 196

Re: ODS tagsets.excelxp GRAPHING not found.

Have you tried the TableEditor tagset?
http://www2.sas.com/proceedings/forum2008/258-2008.pdf
See pg. 27.
Ask a Question
Discussion stats
  • 4 replies
  • 406 views
  • 0 likes
  • 4 in conversation