topic ExcelXP Tageset in ODS and Base Reporting

ExcelXP Tageset

deleted_user — Fri, 21 Sep 2007 13:48:06 GMT

My Problem:

I'm using the ExcelXP tagest with PROC REPORT. It has done wonderfully thus far, however now I am in need of outputting a graph to my spreadsheet. I've tried to search for this and nothing has helped. Any suggestions would be appreciated.

SAS Version: 9.1.3
OS: Solaris

Re: ExcelXP Tageset

Cynthia_sas — Fri, 21 Sep 2007 15:18:02 GMT

Hi:
If you look at this forum posting:
http://support.sas.com/forums/thread.jspa?messageID=6094៎

You will learn that, by Microsoft design, SpreadSheetML language, which is the kind of output created by ExcelXP, doesn't support images. In fact, you should see a note in your SAS log that says:
[pre]
Excel XML does not support output from Proc:?????
Output will not be created.
[/pre]

Your only choices are to use HTML-based tagsets to create your output, such as ODS HTML or preferably, ODS MSOFFICE2K.

cynthia

Re: ExcelXP Tageset

deleted_user — Fri, 21 Sep 2007 15:44:17 GMT

Thanks Cynthia for your reply. I've gone with ODS MSOFFICE2K. I am outputting to xls, and I need device= option in my goptions. How do I know which device is correct? Thank you for your patience by the way. 🙂

Re: ExcelXP Tageset

Cynthia_sas — Fri, 21 Sep 2007 20:10:00 GMT

Hi:
There really is no hard and fast rule for DEVICE=. It depends on the SAS/Graph program you're using and on the kind of "bells and whistles" you've added in your code (such as ANNOTATE or GREPLAY).

If I was just doing some very straightforward SAS/Graph jobs AND I wanted the graphical output to be in Excel, I would probably pick one of these device drivers:
[pre]
DEVICE=ACTIVEX
DEVICE=ACTXIMG
DEVICE=PNG
[/pre]

Personally, I like the look and feel of ActiveX graphs and the ACTXIMG driver gives you the look and feel of ACTIVEX graphics, but without the interactivity.

On the other hand, if you already have a fairly complex SAS/Graph program that looks just the way you want it, then you might be happy with
[pre]
DEVICE=GIF
DEVICE=JPEG
DEVICE=PNG
[/pre]

The Tech Support White paper http://support.sas.com/techsup/technote/ts674/ts674.html
might be another good resource -- it outlines a ton of good information on using SAS/Graph output with Microsoft Office.

cynthia