OUTPUT MODIFY

The OUTPUT MODIFY command applies formatting and other changes to the contents of the active Viewer window.

Note: Square brackets used in the OUTPUT MODIFY syntax chart are required parts of the syntax and are not used to indicate optional elements. Any equals signs (=) displayed in the syntax chart are required. All subcommands except SELECT are optional.
OUTPUT MODIFY NAME={*   }
                   {ALL }
                   {name}

 /REPORT PRINTREPORT = {NO**  }
                       {YES   }
                       
 /SELECT CHARTS HEADINGS LOGS MODELS 
         TABLES TEXTS TREES WARNINGS
         OUTLINEHEADERS UNKNOWN OTHER
         PAGETITLE NOTES
 or
 /SELECT ALL EXCEPT = [list]

 /IF  COMMANDS = ["expression", "expression(integer)"
                  "expression(LAST)", LAST]
      SUBTYPES = ["expression" "expression"...]
      LABELS = [EXACT("expression") BEGINS("expression")
                ENDS("expression") CONTAINS("expression")]
      INSTANCES = [n n... LAST]
      VISIBLEONLY={NO**}
                  {YES }
 
 /DELETEOBJECT DELETE={NO**}
                      {YES }

 /INDEXING
  INDEXTYPE = {NUMBER** }  
              {LETTERLOW}  
              {LETTERCAP}
              {ROMANLOW } 
              {ROMANCAP }
  INDEXSTART = {1**     }
               {integer }
               {"letter"}
               {"roman" }

 /OBJECTPROPERTIES
  VISIBLE = {ASIS**}
            {YES   }
            {NO    }
  OUTLINELABEL = "expression"
  SIZE = {PERCENT    }  ({width, height       })
         {CENTIMETERS}   {PROPORTIONAL, height}
         {INCHES     }   {width, PROPORTIONAL }
         {POINTS     }
 
 /TABLE
  TABLETITLE = "expression"
  TRANSPOSE = {NO**}  
              {YES }
  TLOOK = {"filespec"}
          {"name"    }
          {NONE      }
  SELECTEDLAYER = [{"variable", "category"}]
                   {"variable", number    }
                   {number, "category"    }
                   {number, number        }
  SORT = {COLLABEL("label")  }
       {COLPOSITION(number)}
  SORTDIRECTION = {ASCENDING**} 
                  {DESCENDING }
  TABLESUMMARY = "expression"
  PIVOT = [expression]

 /TABLECELLS
  SELECT = ["expression", COUNT, MEAN, MEDIAN, RESIDUAL, 
            PERCENT, SIGNIFICANCE, VALID, TOTAL, MISSING, 
            CUMULATIVEPERCENT, VALIDPERCENT, POSITION(integer),
            BODY, HEADERS, FOOTNOTES, TITLE, CAPTION, …]
  SELECTDIMENSION = {BOTH** }
                    {COLUMNS}
                    {ROWS   }
  SELECTCONDITION = {ALL**,                                             }
                    {["expression", TOP(integer), BOTTOM(integer), 
                      PARENT(expression), CHILD(expression),…]}
  COLUMNWIDTH = {CENTIMETERS(value)}
                {INCHES(value)     }
                {POINTS(value)     }
  APPLYTO = {CELL**      }
            {COLUMN      }
            {ROW         }
            (COLUMNDATA  }
            {ROWDATA     }
            {COLUMNHEADER}
            {ROWHEADER   }
  REVERTTODEFAULT = {NO**}  
                    {YES }
  FORMAT=format
  FONT = "fontfamily"
  FONTSIZE = value
  STYLE = REGULAR BOLD ITALIC UNDERLINE
  TEXTCOLOR = {color       } 
              {RGB(r, g, b)}	
  BACKGROUNDCOLOR = {color       } 
                    {RGB(r, g, b)}	
  REPLACE = {"expression"}
            {number      }
  HIDE = {NO**}
         {YES }
  UNGROUP = {NO**}
            {YES }

 /GRAPHS
  CTEMPLATE = {["filespec", "filespec", ...]}
              {[name, name, ...]           }
  VIZSTYLESHEET = "stylesheet name"

 /TEXTS
  TEXT = "expression"
  FONT = "fontfamily"
  FONTSIZE = value
  STYLE = REGULAR BOLD ITALIC UNDERLINE
  TEXTCOLOR = {color       } 
              {RGB(r, g, b)}	
  • If included, the REPORT subcommand must be the first subcommand.
  • Multiple blocks of output modifications are allowed. Each block of modification specifications must begin with a SELECT subcommand.
  • Valid color values for TEXTCOLOR and BACKGROUNDCOLOR are BLACK, BLUE, CYAN, DARKGRAY, GRAY, GREEN, LIGHTGRAY, MAGENTA, ORANGE, PINK, RED, WHITE, YELLOW.

This command takes effect immediately. It does not read the active dataset or execute pending transformations. See the topic Command Order for more information.

Release History

Release 27.0
  • Added support for the PIVOT keyword in the TABLES subcommand.
  • Added support for the VALID, TOTAL, MISSING, CUMULATIVEPERCENT, and VALIDPERCENT options in the SELECT keyword for the TABLECELLS subcommand.
  • Added support for the HIDE and UNGROUP keywords in the TABLECELLS subcommand.
  • Added support for the PARENT and CHILD options for the SELECTCONDITION keyword in the TABLECELLS subcommand.

Release 22.0

  • Command introduced.

Example

OUTPUT MODIFY
 /SELECT TABLES
 /IF SUBTYPES=["Frequencies"]
 /TABLECELLS SELECT=["Total"]
  SELECTDIMENSION=ROWS
  STYLE=BOLD APPLYTO=ROW.