PPT Subcommand (OUTPUT EXPORT Command)

The PPT subcommand exports output in PowerPoint format. This is available only on Windows operating systems and requires an installed version of PowerPoint 97 or later.

  • Pivot tables are exported as Word tables, and each table is a separate slide in the PowerPoint file. All formatting attributes of the pivot table are retained--for example, cell borders, font styles, and background colors.
  • Graphics are exported in TIFF format, and each graphic is separate slide in the PowerPoint file. (Note: Graphics includes charts, tree diagrams, and any Model Viewer items, including Model Viewer tables.)
  • Text output is not included.

DOCUMENTFILE Keyword

The required DOCUMENTFILE keyword specifies the name of the PowerPoint document. The keyword is followed by an equals sign and a quoted file specification, as in:

OUTPUT EXPORT
  /PPT DOCUMENTFILE='/mydocs/myresults.ppt'.

SLIDESIZE Keyword

The SLIDESIZE keyword controls the slide dimensions of the exported file. The keyword is followed by an equals sign and one of the following alternatives:

INCHES(width, height). Height and width specified in inches. Both values are required and both must be positive numbers.

MM(width, height). Height and width specified in millimeters. Both values are required and must be positive numbers.

TOPMARGIN, BOTTOMMARGIN, LEFTMARGIN, and RIGHTMARGIN Keywords

These keywords control the margins for the exported document. Each keyword is followed by an equals sign and one of the following alternatives:

INCHES(n). Margin specified in inches. The value must be a positive number.

MM(n). Margin specified in millimeters. The value must be a positive number.

NOTESCAPTIONS Keyword

The NOTESCAPTIONS keyword controls the inclusion of pivot table footnotes and captions in the exported document. The keyword is followed by an equals sign and one of the following alternatives:

YES. Include footnotes and captions. This is the default.

NO. Do not include footnotes and captions.  

SLIDETITLES Keyword

The SLIDETITLES keyword controls the inclusion slide titles of the exported file. The title is formed from the outline entry for the item in the outline pane of the Viewer. The keyword is followed by an equals sign and one of the following alternatives:

YES. Include slide titles. This is the default.

NO. Do not include slide titles.

WIDETABLES Keyword

The WIDETABLES keyword controls the treatment of pivot tables that are too wide for the document width (the specified page width minus the left and right margins). The keyword is followed by an equals sign and one of the following alternatives:

WRAP. Wrap wide tables. The table is divided into sections that will fit within the defined document width. Row labels are repeated for each section of the table. This is the default. If the row labels are too wide for the defined document width, the table is exported without wrapping and will appear truncated in the document.

SHRINK. Shrink wide tables to fit within the document width. Font size and column width are reduced so that the table fits within the document width.

ASIS. Do not shrink or wrap wide tables. The document width expands to accommodate the widest table.

Example

OUTPUT EXPORT
  /PPT DOCUMENTFILE='/mydocs/myresults.ppt'
   SLIDESIZE=INCHES(10, 7.5)
   SLIDETITLES=NO
   WIDETABLES=ASIS.