Samples & SAS Notes > SAS Reference
>
ODS (Output Delivery System)
| Date | Title | Type | ||
|---|---|---|---|---|
| 5/6/09 |
24029 - In ODS RTF, how can I remove all of the grid lines and all of the shading? To remove the grid lines from within the table, specify the attribute RULES=NONE along with BACKGROUND=_UNDEF_. Issue FRAME=VOID within the style element Table in order to remove the borders from around the table. ... http://support.sas.com/kb/24/029.html, 17KB |
Usage Note | ||
| 2/20/09 |
24034 - Can I append to an ODS RTF file? Currently it's not possible to append to an RTF file. This is because an RTF document is composed of orderly parts. As it builds, it stores information for colors, fonts, body, header, and so on. At the close, ... http://support.sas.com/kb/24/034.html, 18KB |
Usage Note | ||
| 10/17/08 |
33590 - Determining the open ODS destinations programmatically Beginning with SAS 9.2, you can programmatically determine which ODS destinations are open. You can perform this task by quering the DICTIONARY.VDEST dictionary table. Querying the DICTIONARY.VDEST table will display ... http://support.sas.com/kb/33/590.html, 19KB |
Usage Note | ||
| 10/17/08 |
23641 - In ODS, how can I name the GIF files that get created? The GPLOT and GCHART procedures have the NAME= option, which goes on the PLOT, VBAR, and HBAR statements. Note that prior to SAS 9.2, the NAME= option limits the name of the GIF file to 8 characters. You can also ... http://support.sas.com/kb/23/641.html, 18KB |
Usage Note | ||
| 1/16/08 |
30935 - How can I center all of the output created by PROC PRINT in ODS? PROC PRINT output routed to the non-LISTING destinations (HTML, PDF & RTF) can be controlled by PROC TEMPLATE or by the STYLE(<location>) option on the PROC PRINT statement. This ODS RTF sample code shows how to ... http://support.sas.com/kb/30/935.html, 20KB |
Sample | ||
| 11/30/07 |
24439 - In SAS 9.1, are there easier ways to customize page numbers in RTF output? Yes, beginning with SAS 9.1, page numbers can be customized in the RTF destination by using an escape character and the {thispage} function, {lastpage} function, {pageof} function, or all three: ods escapechar='^'; ... http://support.sas.com/kb/24/439.html, 17KB |
Usage Note | ||
| 10/18/07 |
24026 - Where can I find documentation about the RTF destination for ODS? New features for Releases 8.1 and 8.2 are documented in SAS System Help. The experimental ODS RTF driver shipped with Version 8 of Base SAS Software. For SAS 9, the SAS Output Delivery System: User's Guide is updated in ... http://support.sas.com/kb/24/026.html, 17KB |
Usage Note | ||
| 10/17/07 |
24168 - How can I modify the header and footer margins in ODS RTF? Beginning in SAS 9.1, you can modify header and footer margins by using the HEADERY= and FOOTERY= options. The values for these options are specified in twips. A twip is specified as 1/20 of a printer's point. There ... http://support.sas.com/kb/24/168.html, 17KB |
Usage Note | ||
| 10/4/07 |
23457 - How can I change the default location where ODS stores unqualified files? If you specify only a filename and not a pathname, then the filename is unqualified. When you specify unqualified files, SAS 8.2 ODS output is stored by default in c:\winnt\profiles\user-ID\Personal\My SAS Files\V8 ... http://support.sas.com/kb/23/457.html, 17KB |
Usage Note | ||
| 10/4/07 |
23455 - How can I modify the default ODS pathname without redefining the entire list? Beginning with Release 8.2, several options on the ODS PATH statement enable you to modify the path without redefining the entire list. The options are as follows: APPEND adds the template store to the end of ... http://support.sas.com/kb/23/455.html, 17KB |
Usage Note | ||
| 10/4/07 |
23450 - I would like to modify the ODS style by only specifying the value that I want to modify. I want the resulting template to be the default. There are two ways to do this. One way is to use PROC TEMPLATE with the SOURCE statement and the FILE= option to save the template source code to a file. This file can then be included and the changes to the ... http://support.sas.com/kb/23/450.html, 17KB |
Usage Note | ||
| 10/3/07 |
23650 - How can I generate RTF, XML, PDF, and Excel files with ODS and SAS/IntrNet? You can use the APPSRV_HEADER function to override the default mime header that ODS generates. The below examples use the function to change the content-type in order to render the desired kind of output. The ... http://support.sas.com/kb/23/650.html, 18KB |
Usage Note | ||
| 10/3/07 |
23653 - Do you have FAQs for using ODS in the z/OS environment? See Tips for Using ODS in the OS/390 Environment for Release 8.2. http://support.sas.com/kb/23/653.html, 16KB |
Usage Note | ||
| 10/3/07 |
24305 - What image formats can I use in ODS? In SAS 9: The JPEG format works across all ODS desinations (under z/OS, you must enable the UNIX file system HFS). ODS HTML supports GIF, JPEG, PNG, ACTXIMG, JAVAIMG, ACTIVEX, JAVA, and more. ODS RTF supports JPEG, ... http://support.sas.com/kb/24/305.html, 17KB |
Usage Note | ||
| 10/3/07 |
24309 - Why isn't there any ODS output for the last procedure in my job? Ensure that you submit run; quit; before your ods destination close; Be aware that in SAS jobs, "step boundaries" separate each PROC or DATA step. The output from a SAS procedure is not complete until the ... http://support.sas.com/kb/24/309.html, 17KB |
Usage Note | ||
| 10/3/07 |
23675 - How can I generate multiple copies of output from the same ODS destination? In Release 8.2, you can generate an extra copy of the output from the same destination by using a destination alias. The below example generates HTML and sends it to the server with SAS/IntrNet, and also ... http://support.sas.com/kb/23/675.html, 17KB |
Usage Note | ||
| 10/3/07 |
23669 - How can I selectively exclude output from my ODS file? You can select or exclude output objects by issuing the ODS SELECT or ODS EXCLUDE statement. By default, this method excludes or selects output objects for all destinations. To select or exclude output for a ... http://support.sas.com/kb/23/669.html, 18KB |
Usage Note | ||
| 10/3/07 |
23339 - Can I uppercase the procedure title in ODS output? The procedure title can be uppercased or lowercased by using the Text-transform style property within the style element Proctitle. proc template; define style styles.test; parent=styles.default; style ... http://support.sas.com/kb/23/339.html, 17KB |
Usage Note | ||
| 10/3/07 |
23338 - How can I remove the procedure title from my ODS output? The procedure title ("The Means Procedure") can be removed beginning in Release 8.1 by using the ODS NOPROCTITLE statement. This is supported in all destinations including the listing. Prior to Release 8.1, ... http://support.sas.com/kb/23/338.html, 17KB |
Usage Note | ||
| 10/1/07 |
23330 - What options are available for the TITLE and FOOTNOTE statements in ODS? Below are the available options beginning with Release 8.1 for the HTML, PDF, and RTF destinations. These are similar to the SAS/GRAPH options for titles and footnotes. BOLD specifies bold. COLOR= specifies the ... http://support.sas.com/kb/23/330.html, 18KB |
Usage Note | ||
| 10/1/07 |
24307 - Which title and footnote attributes take precedence in ODS? SAS 8.2 and later releases support several ways to change the appearance of titles and footnotes. The following rules determine which attribute takes precedence. In general, the most specific or closest setting wins. ... http://support.sas.com/kb/24/307.html, 17KB |
Usage Note | ||
| 10/1/07 |
23637 - How can I dynamically FTP output from ODS from a SAS job? To dynamically transfer output by FTP from a SAS job, specify the FILENAME statement with the FTP access method. This creates the output file on the target host. In the HOST= argument, specify the IP ... http://support.sas.com/kb/23/637.html, 19KB |
Usage Note | ||
| 8/28/07 |
24054 - In ODS, how can I add special characters such as GE or LE to my output? You can add special symbols such as ≥ (greater than or equal to) or ≤ (less than or equal to) by using the appropriate fonts that have these symbols. For instance, the GE and LE characters are available in ... http://support.sas.com/kb/24/054.html, 18KB |
Usage Note | ||
| 8/28/07 |
24023 - In ODS RTF, how can I modify the font style of the titles? The font style for the titles and footnotes can be changed by modifying the argument associated with the string 'TitleFont'. The font style "italic" can be removed from the argument; see example 1. This can also ... http://support.sas.com/kb/24/023.html, 18KB |
Usage Note | ||
| 8/28/07 |
24041 - In ODS RTF, can I change the location of the page numbers and the date from the top right corner? The location of the page number and date can be modified by adding RTF code to the TITLE or FOOTNOTE statement. First issue the system options NONUMBER and NODATE to remove the default page number and date. ... http://support.sas.com/kb/24/041.html, 18KB |
Usage Note | ||
| 8/28/07 |
24488 - Can I use a relative path to point to an image I want to place in an ODS PDF or ODS RTF file? When you place an image in an RTF file with PREIMAGE= or POSTIMAGE=, you can specify an absolute or URL reference. ods rtf file="file.rtf"; proc report nowd data=sashelp.class style(report)={preimage='directory- ... http://support.sas.com/kb/24/488.html, 17KB |
Usage Note | ||
| 8/27/07 |
24025 - In ODS RTF, how can I change the fonts of the column headers? The fonts for the column headers can be changed by modifying the fonts associated with the string 'headingFont'; see example 1. This can also be done by modifying the style element Header; see example 2. ... http://support.sas.com/kb/24/025.html, 18KB |
Usage Note | ||
| 7/30/07 |
23636 - How can I dynamically e-mail output from ODS? To dynamically e-mail output from ODS in a SAS program, specify the EMAIL device on the FILENAME statement along with the e-mail address and any other of the e-mail options that you would like. In addition, specify the ... http://support.sas.com/kb/23/636.html, 19KB |
Usage Note | ||
| 4/17/07 |
24559 - Can I change the orientation inside an RTF or PDF file? Starting in SAS 9, the following logic can be used to create an RTF file which toggles orientation inside the file. The same capability is not currently available with the ODS PRINTER destinations (PCL/PDF/PS); however, ... http://support.sas.com/kb/24/559.html, 17KB |
Usage Note | ||
| 9/28/06 |
24606 - Creating tabular output with DATA step and ODS using a custom template Specify the FILE PRINT ODS statement to create an output object with the DATA step. Use PROC TEMPLATE to define a custom table definition. Include footers that span specified columns. http://support.sas.com/kb/24/606.html, 20KB |
Sample | ||
| 8/30/06 |
24035 - In ODS RTF, can I prevent the titles and footnotes from being written to the headers and footers of a file? Starting in Release 8.2, the experimental BODYTITLE option places the titles and footnotes with the output instead of in the header and footer sections of the RTF file. ods rtf file='temp.rtf' bodytitle; ... http://support.sas.com/kb/24/035.html, 17KB |
Usage Note | ||
| 2/27/06 |
24492 - When I use J= on my TITLE, the text is wrapping - why? When multiple J= options are used on a TITLE or FOOTNOTE statement, the space for this TITLE or FOOTNOTE is divided into 3 equal parts. If one portion of the TITLE or FOOTNOTE takes up more than 1/3 of the space, the ... http://support.sas.com/kb/24/492.html, 18KB |
Usage Note | ||
| 2/9/06 |
24039 - What release of Microsoft Word is recommended for reading RTF files created by ODS? Release 8.1 creates files readable by MS Word 97 and later. Release 8.2 and SAS 9 create files readable in MS Word 2000 and later. SAS 9.1 and later create RTF files readable in MS Word 2002 and later. See more ... http://support.sas.com/kb/24/039.html, 17KB |
Usage Note | ||
| 2/8/06 |
24489 - How can I reduce or shrink the font sizes throughout my RTF document? Use PROC TEMPLATE to create a style that redefines the font sizes for the FONTS list. Most PROCs and the DATA step with FILE PRINT ODS, use the following fonts: DOCFONT, HEADINGFONT and TITLEFONT. The below code shrinks ... http://support.sas.com/kb/24/489.html, 17KB |
Usage Note | ||
| 1/10/06 |
24046 - In ODS, how can I add a superscript or subscript value to my title or footnote? Superscript and subscript characters can be added by using the experimental ODS ESCAPECHAR= statement in Release 8.2 and later. This method can be used for HTML, MARKUP, PCL, PDF, PS (PostScript) and RTF destinations. ... http://support.sas.com/kb/24/046.html, 17KB |
Usage Note | ||
| 12/8/05 |
24750 - Using a simple user-defined TEMPLATE definition Create a phone list through the FILE PRINT ODS statement to an HTML file using a simple user-defined TEMPLATE definition called PHONELIST. http://support.sas.com/kb/24/750.html, 41KB |
Sample | ||
| 11/30/05 |
24460 - Can I add a standard line of text to all of my ODS output? You can use PROC TEMPLATE to change or create a style definition. Specify text with the POSTTEXT= argument in the PAGENO style element. Then when you specify the style, the text appears beneath the page number in the ... http://support.sas.com/kb/24/460.html, 18KB |
Usage Note | ||
| 9/14/05 |
24042 - In ODS RTF, can I get my page numbers in page X of Y format? In SAS 9 and later, the experimental in-line formatting function {PAGEOF}, produces page X of Y numbering with Word 2000 and higher. Prior to SAS 9, you can add raw RTF code in the TITLE or FOOTNOTE statement. Below is ... http://support.sas.com/kb/24/042.html, 17KB |
Usage Note | ||
| 8/24/05 |
24040 - In ODS RTF, can I prevent output from going to a new page? Release 8.2 introduces the STARTPAGE= option, which gives you more control of the pagination in ODS RTF. The STARTPAGE= option values are (YES, ON), (NO, OFF), and NOW. For more information about STARTPAGE= see ... http://support.sas.com/kb/24/040.html, 17KB |
Usage Note | ||
| 7/25/05 |
24314 - How can I underline text when writing to PDF or RTF using FILE PRINT? You can get underlining in RTF by using RTF control words with inline formatting. "\UL" starts the underlining, and "\UL0" stops the underlining. If you are unsure whether your chosen ESCAPECHAR is a special character ... http://support.sas.com/kb/24/314.html, 18KB |
Usage Note | ||
| 7/11/05 |
23664 - How can I send ODS output to Excel, Word, PowerPoint, and Oracle? There are many ways to read ODS output with Excel, Word, PowerPoint, SPSS, Oracle, and Access. Excel Excel from HTML and CSV The bullets below contain syntax to get you started. For more in-depth information, see ... http://support.sas.com/kb/23/664.html, 21KB |
Usage Note | ||
| 4/6/05 |
24961 - Using ODS to Generate RTF Output on the Mainframe In this example, a SAS program running on z/OS generates PROC MEANS output as an RTF file. The RTF file is generated as an HFS (Hierarchical File System) file on the z/OS computer, where it is accessed by a standard ... http://support.sas.com/kb/24/961.html, 19KB |
Sample | ||
| 4/6/05 |
24962 - Using ODS to Generate an RTF File Directly On a PC In this example, a SAS program running on z/OS generates PROC MEANS output in RTF format and writes it to a PC file. Once on the PC, it is accessed as a PC file by a standard word processing program. http://support.sas.com/kb/24/962.html, 20KB |
Sample | ||
| 9/21/04 |
24165 - What has changed in ODS from SAS 8.2 to 9.1? For changes to the SAS Output Delivery System (ODS), see A Soft Landing to ODS 9.1. http://support.sas.com/kb/24/165.html, 17KB |
Usage Note | ||
| 7/1/04 |
24043 - In ODS RTF, can I reset my page numbers? The PAGENO= option doesn't seem to have any effect. The PAGENO= option does not work with RTF in Releases 8.1 and 8.2. The solution is to insert RTF code to specify the page numbers. The RTF code PGNSTART resets or sets the starting page. Here is an example that ... http://support.sas.com/kb/24/043.html, 17KB |
Usage Note | ||
| 7/1/04 |
24038 - What device should I use with SAS/GRAPH and ODS RTF? Prior to Release 8.2, the PNG (Ping) driver is used by default when generating graphs with SAS/GRAPH and ODS RTF. Release 8.2 uses the EMF (Enhanced Metafile) driver by default, but the ACTIVEX driver is also ... http://support.sas.com/kb/24/038.html, 17KB |
Usage Note | ||
| 6/29/04 |
24031 - In ODS RTF, how can I remove all of the shading and the bolding while maintaining the grid lines? The shading and the bolding can be removed by applying the style template STYLES.MINIMAL, which is one of the default style templates shipped with SAS; see example 1. This can also be done by using the style ... http://support.sas.com/kb/24/031.html, 17KB |
Usage Note | ||
| 6/29/04 |
24028 - In ODS RTF, how can I remove all of the grid lines from within the table except from beneath the column headers? To remove all of the grid lines except the ones beneath the column headers, use the RULES=GROUPS attribute within the style element Table. Issue the BACKGROUND=_UNDEF_ attribute to prevent the background color of ... http://support.sas.com/kb/24/028.html, 17KB |
Usage Note | ||
| 6/29/04 |
24056 - How can I create ODS RTF output that looks exactly like my listing output? ODS generates tabular output. Therefore, there is no direct way to make the ODS RTF output look like the SAS listing output. Here are a couple of indirect ways. The example below uses PROC PRINTTO to save the ... http://support.sas.com/kb/24/056.html, 18KB |
Usage Note | ||
| 6/29/04 |
24030 - In ODS RTF, how can I remove the bold from the row headers after I remove the grid lines? The font for the row header can be modified in the style element RowHeader. In the example code below, the row header font is changed to that of the cell values. The docFont font is defined in the parent ... http://support.sas.com/kb/24/030.html, 17KB |
Usage Note | ||
| 6/29/04 |
24027 - IN ODS RTF, how can I remove the grid lines from within the table and the box from around the table? The grid lines can be removed from within the table by specifying the attributes RULES=NONE and BACKGROUND=_UNDEF_. The rules showing between the cells are the background color of the table. By default in Release ... http://support.sas.com/kb/24/027.html, 17KB |
Usage Note | ||
| 6/29/04 |
24033 - How can I set the margins for the ODS RTF destination? You can set the margins of the RTF file by using PROC TEMPLATE and specifying the LEFTMARGIN=, RIGHTMARGIN=, TOPMARGIN=, and BOTTOMMARGIN= attributes. By default, the margins are .25in on all sides. proc ... http://support.sas.com/kb/24/033.html, 17KB |
Usage Note | ||
| 6/29/04 |
24057 - In ODS RTF, can I prevent my titles from disappearing when I use the STARTPAGE=NO option? When the STARTPAGE=NO option is specified, the default is to remove the titles and footnotes. There is no way currently supported to make them appear, other than restoring the option to the default of STARTPAGE= ... http://support.sas.com/kb/24/057.html, 18KB |
Usage Note | ||
| 6/29/04 |
24055 - In ODS RTF, why am I still getting gray lines after removing all of the borders from the table? The light gray lines only display when viewed and not when printed. To make them disappear or appear, in Word change the Gridlines option under the Table menu. See more information about PROC TEMPLATE and the RTF ... http://support.sas.com/kb/24/055.html, 17KB |
Usage Note | ||
| 6/29/04 |
24053 - Why do I get a dialog box in the Results Viewer when I create ODS RTF files? When you generate RTF files with ODS, and you get a dialog box in the Results Viewer and no RTF file rendered in Word, then either you do not have MS Word or the Word Viewer installed, or, if you have one of ... http://support.sas.com/kb/24/053.html, 17KB |
Usage Note | ||
| 6/29/04 |
24051 - In ODS RTF, how can I generate HTML hyperlinks? HTML hyperlinks can be generated with the RTF destination by using the URL= attribute. For example, if you want to add a hyperlink for the column headers, use the URL= attribute directly in the procedures that ... http://support.sas.com/kb/24/051.html, 18KB |
Usage Note | ||
| 6/29/04 |
24052 - In ODS RTF, how can I get the correct fonts under an operating environment other than Windows? With regard to RTF, sometimes you can't find the font you want. In many cases, the Windows font exists as an Adobe font, but the name is slightly different. (SAS uses Adobe fonts under operating environments other than ... http://support.sas.com/kb/24/052.html, 17KB |
Usage Note | ||
| 6/29/04 |
24050 - In ODS RTF, how can I create a table of contents? You can create a table of contents in the RTF destination by following the below three steps. View output. Use the RTF control word \S1 to specify each entry in the table of contents. options number nodate; ... http://support.sas.com/kb/24/050.html, 18KB |
Usage Note | ||
| 6/29/04 |
24049 - How can I display ODS RTF output in the browser with SAS/IntrNet? For information about sending RTF output to an HTML browser by using SAS/IntrNet, see FAQ 3600. See more information about PROC TEMPLATE and the RTF destination. http://support.sas.com/kb/24/049.html, 17KB |
Usage Note | ||
| 6/29/04 |
24047 - In ODS RTF, how can I add images to my output file? Here are two ways you can add images to an RTF file. Beginning with Release 8.2 in ODS RTF, you can add an image before a table with PREIMAGE= and after a table with POSTIMAGE= in PROC TEMPLATE. Below is an ... http://support.sas.com/kb/24/047.html, 18KB |
Usage Note | ||
| 6/29/04 |
24048 - Which style elements and attributes affect the ODS RTF destination? By default, the RTF destination uses the style template STYLES.RTF, which inherits from STYLES.PRINTER, which in turn inherits from STYLES.DEFAULT. However, not all elements and attributes are used by the ... http://support.sas.com/kb/24/048.html, 17KB |
Usage Note | ||
| 6/29/04 |
24044 - Just when I thought the ODS RTF destination was boring, you add animation. You can spice up an RTF file by adding the \animtextN control word to the TITLE or FOOTNOTE statement. View output. ods rtf body='c:\test\rtf13.rtf'; proc report data=sashelp.class nowd; title '{\animtext1 ... http://support.sas.com/kb/24/044.html, 17KB |
Usage Note | ||
| 6/29/04 |
24045 - In ODS RTF, can I modify the alignment from always being centered on the decimal? You can modify the decimal alignment by using RTF code within the PRETEXT= attribute. In the below example, X is trying to force decimal alignment on unruly data. It does this by specifying a style override on ... http://support.sas.com/kb/24/045.html, 18KB |
Usage Note | ||
| 6/29/04 |
24037 - In ODS RTF, I specified the fonts "Helvetica" and "Times New" with PROC TEMPLATE but they were not used. Prior to Release 8.2, some fonts don't get passed from PROC TEMPLATE to Word. This is fixed in Release 8.2. See more information about PROC TEMPLATE and the RTF destination. http://support.sas.com/kb/24/037.html, 17KB |
Usage Note | ||
| 6/29/04 |
24032 - In ODS RTF, why don't my column headers repeat when my output splits over a new page? ODS measures tables, titles, and notes horizontally on a page. This allows ODS to break and wrap tables that are too wide for a page. However, ODS does not measure the page vertically. Instead, measuring ... http://support.sas.com/kb/24/032.html, 17KB |
Usage Note | ||
| 6/29/04 |
24036 - In ODS RTF, can I generate landscape output rather than the default portrait? Specify the system option ORIENTATION=LANDSCAPE in order to create landscape output with the RTF destination. This option also works with default SAS output. See more information about PROC TEMPLATE and the RTF ... http://support.sas.com/kb/24/036.html, 17KB |
Usage Note | ||
| 6/29/04 |
24024 - In ODS RTF, how can I change the fonts of the cell values? The fonts of the cell values can be changed by modifying the value associated with the string 'docFont'; see example 1. This can also be done by modifying the style element Data; see example 2. * Example 1 * ... http://support.sas.com/kb/24/024.html, 18KB |
Usage Note | ||
| 6/29/04 |
24022 - In ODS RTF, how can I modify the foreground colors of the document? The foreground colors can be modified by replacing the argument associated with the string 'fg'. View output. proc template; define style styles.newrtf; parent=styles.RTF; replace color_list "Colors ... http://support.sas.com/kb/24/022.html, 17KB |
Usage Note | ||
| 6/29/04 |
24021 - In ODS RTF, how can I change the background color of the column headers? The background colors of the headers can be changed by modifying the argument associated with the string 'bgH', as shown below. The default value for this string is 'graybb'. This could also be done by ... http://support.sas.com/kb/24/021.html, 17KB |
Usage Note | ||
| 6/29/04 |
24020 - In ODS RTF, how can I modify the colors of my cell values? Modifying the colors of the cell values can be accomplished by replacing the value associated with the string 'bg' in the Color_list style element. This can also be done by modifying the style element Data, which ... http://support.sas.com/kb/24/020.html, 17KB |
Usage Note | ||
| 2/9/04 |
23673 - What style elements are supported under the various ODS destinations? For SAS Version 8, see a table of style elements, which lists the ODS destinations that are supported for each element. See also the task-oriented table of attributes, which lists the destinations that are ... http://support.sas.com/kb/23/673.html, 18KB |
Usage Note | ||
