ExcelXP Tageset

[deleted_user]

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

[Cynthia_sas]

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

[deleted_user]

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. 🙂

[Cynthia_sas]

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