Exporting Your Graphs to Microsoft Office Products |
The SAS/GRAPH software can generate the following types of graphics output that can be imported into Microsoft products:
EMF and WMF | JPEG and TIFF | HTML (PNG) | ACTIVEX (RTF) |
CGM | GIF and BMP | RTF | ACTXIMG (PNG) |
PNG | EPS | ACTIVEX (RTF) | JAVAIMG (PNG) |
Note the following:
The ODS HTML destination generates two files: a PNG file (by default) that contains the graph and an HTML file that enables you to view the graph file.
The ACTIVEX device is used with the ODS RTF or ODS HTML destination to create an RTF or HTML file that contains code that is consumed by the ActiveX Control.
The ACTXIMG and JAVAIMG devices generate a PNG file that contains a static graph that is generated by the ACTIVEX and JAVA devices respectively.
Procedures that do not support the ACTIVEX, ACTXIMG, JAVA, and JAVAIMG devices produce a GIF file when the ACTIVEX, ACTXIMG, JAVA, or JAVAIMG device is used.
Comparison of the Graphics and Document Types provides a brief comparison of these graphics output formats and lists some of the graphics output devices that generate each output type. For detailed information on all of the graphics output devices, see Overview.
Type | Advantages and Limitations | Devices |
---|---|---|
EMF and WMF |
Advantages:
Limitations:
|
|
CGM |
Advantages:
Limitations:
|
|
PNG |
Advantages:
Limitation: cannot be resized without a loss of quality. |
|
JPEG and TIFF |
Advantages:
Limitations:
|
|
GIF and BMP |
Advantages:
Limitations:
|
|
EPS |
Advantages:
Limitations:
|
|
HTML |
Advantages:
Limitation: In Office 97, the images are not loaded into a PowerPoint or Excel document when the HTML is imported. Only the text and tables are imported. |
|
RTF |
Advantages:
|
|
Working Around the EMF and CGM Transparency Limitation |
For the EMF and CGM devices, you can work around the transparency limitation as follows:
For EMF, use the CBACK= or IBACK= graphics options to assign the matching color or image for the graph background. You could instead edit the EMF file after it is imported to remove the default background.
For CGM, use the CBACK= graphics to assign a matching background color to the CGM file. The CGM devices do not support the IBACK= graphics option or the IMAGE function. To have an image in the document or slide appear as the background of the graph, edit the graph after it is imported to remove the background created by SAS so that the document background shows through.
About the Default CGM Filter for Microsoft Office |
To import CGM files in Microsoft Office, you must install the default CGM filter. For information on the CGM filter and how to install it for your version of Microsoft Office, visit the Microsoft Support Web site:
http://support.microsoft.com
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.