File Name: Tipsheet_ods_layout.pdf
File Size: 855.57 KB
File Type: Application/pdf
Last Modified: 2 years
Status: Available
Last checked: 16 days ago!
This Document Has Been Certified by a Professional
100% customizable
Language: English
We recommend downloading this file onto your computer
ODS Layout ODS Layout Tip Sheet Absolute Layout Example Gridded Layout Example Absolute Absolute Layout LayoutExample Example options nocenter obs=5; Gridded GriddedLayout LayoutExample Example ods pdf file='gridded.pdf'; ods pdfoptions options file='absolute.pdf'; nocenter nocenter obs=5; obs=5; ods ods pdf pdf file='gridded.pdf'; file='gridded.pdf';ods ods pdf pdf file='absolute.pdf'; file='absolute.pdf'; ods layout absolute ods layout gridded ods ods layout layout gridded columns=2 width=5in ODSLayout Layoutods ods layout layout absolute x=0cm y=0cm absolute gridded column_gutter=.25in columns=2 columns=2 width=5in width=5in ODS ODS Layout width=17cm x=0cm x=0cm y=0cm height=23cm y=0cm style={background=lightgray}; style={background=lightgray}; column_gutter=.25in column_gutter=.25in width=17cm width=17cm height=23cm height=23cm style={background=lightgray}; style={background=lightgray}; TipSheet Sheet style={background=lightgray}; style={background=lightgray}; ods region x=1cm y=1cm ods region ods ods region region x=1cm width=10cm x=1cm y=1cm height=10cm y=1cm style={background=lightred}; width=10cm width=10cm height=10cm height=10cm style={background=lightred}; style={background=lightred}; ods ods region region style={background=lightblue}; style={background=lightblue}; style={background=lightblue}; proc means data=sashelp.class mean; Tip Tip Sheet proc report data=sashelp.class run; proc proc means means data=sashelp.class data=sashelp.class mean; mean; proc nowd; data=sashelp.class proc report report data=sashelp.class run; column name age; run; nowd; nowd; proc report nowd run; name column column name age; age; procdata=sashelp.class(obs=5) proc report report nowd nowd run; run; ods region x=2cm y=2cm nowd; data=sashelp.class(obs=5) data=sashelp.class(obs=5) run; nowd; nowd; ods ods region region x=2cm width=10cm x=2cm y=2cm height=10cm y=2cm style={background=lightblue}; width=10cm width=10cm height=10cm height=10cm run; run; ods region width=2in style={background=lightblue}; style={background=lightblue}; proc report data=sashelp.cars ods ods region region style={background=lightblue}; width=2in width=2in procnowd; proc report report data=sashelp.cars data=sashelp.cars style={background=lightblue}; style={background=lightblue}; column make model; nowd; nowd; proc print run; make column column make model; model; procdata=sashelp.class(obs=5 proc print print run; run; keep=name age); data=sashelp.class(obs=5 data=sashelp.class(obs=5 ods region x=3cm y=3cm run; keep=name keep=name age); age); ods ods region region x=3cm width=10cm x=3cm y=3cm height=10cm y=3cm run; run; style={background=lightgreen}; width=10cm width=10cm height=10cm height=10cm ods layout end; This tip sheet places frequently used style={background=lightgreen}; style={background=lightgreen}; proc report data=sashelp.shoes ods ods layout layout end; end; For complete information, refer to the Base SAS® This This tip tipsheet sheetplaces information places in onefrequently frequently place, on used usedsheet of one nowd; data=sashelp.shoes ods pdf close; proc proc report report data=sashelp.shoes documentation at information information ininone one place, place, paper, so you don’t have to search on on one one sheet sheetthrough ofof the column product sales; nowd; nowd; ods ods pdf pdf close; close; run; product column column product sales; sales; support.sas.com/base paper, paper, online documentation. It also gives you the soso you you don’t don’t have have to to search search through through the run; run; online online documentation
something to take home, ItItalso alsotype gives gives in,you you and try
ods layout end;ods ods layout layout end; end; something somethingtototake takehome,home,type typein,in,andandtry. try
ods pdf close; Creating custom reports that show your ods pdfods pdf close; close; Creating Creating informationcustom custom inreports reports just thethatthat rightshow show wayyour your is now information information possible using ininjust justODS the theright rightway Layout. way isisnow ODS now Layout has possible possible using two distinctusingODS ODS forms,Layout
absoluteODS ODS Layout andLayout gridded.has has Each two two distinct distinct form forms, forms, is suited toabsolute absolute differentand and gridded
reporting Each Each tasks. The form form isissuited most suited importanttotodifferent different decision reporting reporting when using tasks
ODS The The most most important important Layout decision decision is selecting thewhen when type using usingbest that ODS ODS suits your Layout Layout report isisselecting selecting design. the thetype Absolute typelayout that thatbestbest suits is valid suits your foryour report report design
Printer design. Absolute Absoluteonly
destinations layout layout isisvalid Gridded validlayout for for is valid Printer Printer destinations destinations for Printer, HTML, only
andGridded Griddedlayout SASReport. layoutisisvalidvalid SAS Institute Inc. World Headquarters for forPrinter, Printer,HTML, HTML,and andSASReport
+1 919 677 8000 sas.com/offices SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are trademarks of their respective companies. Copyright © 2019, SAS Institute Inc. All rights reserved. 1901904.0319 ODS Layout Tip SheetCommonCommon Common CommonLayout Layout Layout Layout Options Options Options Options and and and and Values Values Values Values Absolute Absolute Absolute AbsoluteLayout Layout Layout Layout Syntax Syntax Syntax Syntax Gridded Gridded Gridded GriddedLayout Layout Layout Layout Syntax Syntax Syntax Syntax Gridded Gridded Gridded GriddedLayout Layout Layout Layout Syntax Syntax Syntax Syntax (continued) (continued) (continued) (continued) (continued) (continued) (continued) (continued)The The The The style= style= style= style=option option option option and and and and option option option option values values values values listed listed listed listed ods ods ods ods layout layout layout layout gridded gridded griddedoptions griddedoptions options options ;;;;below below below beloware are are are used used used used by by by by the the the the layout layout layout layout and and and and region region region regionoptions options options options width=dimension width=dimension width=dimension width=dimension row_gutter=dimension row_gutter=dimension row_gutter=dimension row_gutter=dimensionin ininthis in this this this tip tip tip tip sheet
sheet. specifies specifies specifies specifies horizontal horizontal horizontal horizontal width width width width of ofofthe ofthe the the layout
IfIfIfIf x=dimension x=dimension x=dimension x=dimension specifies specifies specifies specifies space space space space between between between between each each each each row
omitted, omitted, omitted, omitted, itititdefaults defaults itdefaults defaults to totothe to the the the maximum maximum maximum maximum horizontal horizontal horizontal horizontal specifies specifies specifies specifies horizontal horizontal horizontal horizontal position position position position ofofofthe of the the the layout, layout, layout, layout,dimension dimension dimension dimension space space space space available available available available on on on on the the the the page
page. which which which which extends extends extends extendsto totothe to the the the right right right right of ofofthis ofthis this this position
IfIfIfIf order_type=row_major order_type=row_major order_type=row_major order_type=row_major | |column_major |column_major |column_major column_majorindicates indicates indicates indicates aapositive apositive apositive positive integer integer integer integer or ororfloating orfloating floating floating point point point point omitted, omitted, omitted, omitted, the the the the layout layout layout layout container container container containerisisiscentered is centered centered centeredon on on on the the the the indicates indicates indicates indicates which which which which direction direction direction direction the thethe the grid grid grid grid isisispopulated
is populated
value value value value followed followed followed followed by byby by one one one one of ofofthe ofthe the the following following following following units: units: units: units: height=dimension height=dimension height=dimension height=dimension page
page. Printer Printer Printer Printer destination destination destination destination only
in ininin –––inches inches –inches inches specifies specifies specifies specifies vertical vertical vertical vertical height height height height of ofofthe ofthe the the layout
IfIfIfIf advance=explicit advance=explicit advance=explicit advance=explicit| |proc |proc |proc proc | |table |table |table table | |bygroup |bygroup |bygroup bygroup omitted, omitted, omitted, omitted, itititdefaults it defaults defaults defaults to totothe to the the the maximum maximum maximum maximum vertical vertical vertical vertical y=dimension y=dimension y=dimension y=dimension cm cmcmcm–––centimeters centimeters –centimeters centimeters (2.54 (2.54 (2.54 (2.54 cm cm cm cm ===11=1inch) inch) 1inch) inch) specifies specifies specifies specifies vertical vertical vertical vertical position position position positionof ofofthe ofthe the the layout, layout, layout, layout,which which which which specifies specifies specifies specifies which which which which output output output output type type type type advances advances advances advances to totothe to the the the mm mmmmmm –––millimeters millimeters –millimeters millimeters(25.4 (25.4 (25.4 (25.4 mm mm mm mm ===11=1inch) inch) 1inch) inch) space space space space available available available available on on on on the the the the page
page. next next next next region
extends extends extends extends down down down down from from from from this this this this position
position.IfIfIfomitted, If omitted, omitted, omitted, itititit %% % %(pct) (pct) (pct) (pct) --percentage -percentage -percentage percentage (percentage (percentage (percentage (percentage of ofofof defaults defaults defaults defaults to totothe to the the the current current current current vertical vertical vertical verticalposition position position position on on on on the the the the container container container container width width width width or ororheight orheight height height for for for for page
width= width= width= width= and and and and height=) height=) height=) height=) Absolute Absolute Absolute AbsoluteLayout Layout Layout Layout Region Region Region Region Syntax Syntax Syntax Syntax Gridded Gridded Gridded GriddedLayout Layout Layout Layout Region Region Region Region Syntax Syntax Syntax Syntax px pxpxpx –––pixels pixels –pixels pixels width=dimension width=dimension width=dimension width=dimension ods ods ods ods region region regionoptions regionoptions options options ;;;; pt ptptpt –––points points –points points(1/72 (1/72 (1/72 (1/72 inch) inch) inch) inch) ods ods ods ods region region regionoptions regionoptions options options ;;;; specifies specifies specifies specifies horizontal horizontal horizontal horizontal width width width widthof ofofthe ofthe the the layout
IfIfIfIf omitted, omitted, omitted, omitted, itititdefaults defaults itdefaults defaultsto totothe to the the the maximum maximum maximum maximum horizontal horizontal horizontal horizontalinteger integer integer integer x=dimension x=dimension x=dimension x=dimension space space space space needed needed needed needed to totodisplay to display display display all all all all regions
regions. width=dimension width=dimension width=dimension width=dimensionindicates indicates indicates indicates aapositive apositive apositive positive integer
integer. specifies specifies specifies specifies horizontal horizontal horizontal horizontal position position position position of ofofthe ofthe the the region region region region specifies specifies specifies specifies horizontal horizontal horizontal horizontal width width width width of ofofthe ofthe the the region region region region and and and and isisisis within within within within the the the the layout, layout, layout, layout, which which which which extends extends extends extends to totothe to the the the right
IfIfIfIf height=dimension height=dimension height=dimension height=dimension restricted restricted restricted restricted by by by by the the the the layout layout layout layout dimensions
style=style-element{style-attributes} style=style-element{style-attributes} style=style-element{style-attributes} style=style-element{style-attributes} specifies specifies specifies specifies vertical vertical vertical verticalheight height height height of ofofthe ofthe the the layout
IfIfIfIf omitted, omitted, omitted, omitted, itititdefaults defaults itdefaults defaults to toto0
to 0.0.0. height=dimension height=dimension height=dimension height=dimensionall all all all layout layout layout layout and and and and region region region region statements statements statements statements accept accept accept accept the the the the omitted, omitted, omitted, omitted, itititdefaults defaults itdefaults defaultsto totothe to the the the maximum maximum maximum maximum vertical vertical vertical vertical space space space space needed needed needed needed to totodisplay to display display display all all all all regions
regions. specifies specifies specifies specifies vertical vertical vertical vertical height height height height of ofofthe ofthe the the region region region region and and and and isisisisstyle= style= style= style= option
This This This This statement statement statement statement allows allows allows allows you you you you to tototo y=dimension y=dimension y=dimension y=dimension restricted restricted restricted restricted by by by by the the the the layout layout layout layout dimensions
specify specify specify specify aastyle astyle astyle style element element element elementand and and and style style style style overrides
overrides. specifies specifies specifies specifies vertical vertical vertical vertical position position position position of ofofthe ofthe the the region region region region within within within within columns=integer columns=integer columns=integer columns=integer(style= (style= isisis (style= (style= pre-production pre-production ispre-production pre-production ininin SAS in SAS SAS SAS 9.4) 9.4) 9.4) 9.4) the the the the layout, layout, layout, layout,which which which which extends extends extends extends down
down. IfIfIfomitted, If omitted, omitted, omitted, itititit specifies specifies specifies specifies fixed fixed fixed fixed number number number number of ofofcolumns ofcolumns columns columns in ininthe in the the the column=integer column=integer column=integer column=integer defaults defaults defaults defaults to toto0
to 0.0.0. gridded gridded gridded gridded layout
IfIfIfomitted, If omitted, omitted, omitted,itititdefaults defaults itdefaults defaults tototo1
to 1.1.1. specifies specifies specifies specifies the the the the current current current current column column column column position position position position in ininthe in the the the Absolute Absolute Absolute AbsoluteLayout Layout Layout Layout Syntax Syntax Syntax Syntax gridded gridded gridded gridded layout
width=dimension width=dimension width=dimension width=dimension column_widths column_widths column_widths column_widths =(dimension-1 =(dimension-1 =(dimension-1 =(dimension-1 ………dimension-n) …dimension-n) dimension-n) dimension-n) ods ods ods ods layout layout layout layout absolute absolute absoluteoptions absoluteoptions options options ;;;; specifies specifies specifies specifies width width width width of ofofeach ofeach each each column
column. column_span=integer column_span=integer column_span=integer column_span=integer specifies specifies specifies specifies horizontal horizontal horizontal horizontal width width width width of ofofthe ofthe the the region, region, region, region, and and and and isisisis specifies specifies specifies specifies the the the the number number number number of ofofcolumns ofcolumns columns columns that that that that the the the the region region region region restricted restricted restricted restricted by byby by the the the the layout layout layout layout dimensions
dimensions. IfIfIfomitted, If omitted, omitted, omitted, column_gutter=dimension column_gutter=dimension column_gutter=dimension column_gutter=dimension will will will will occupy
The The The The default default default defaultvalue value value value isisis1
is 1.1.1
x=dimension x=dimension x=dimension x=dimension itititdefaults defaults itdefaults defaults to totothe to the the the maximum maximum maximum maximum horizontal horizontal horizontal horizontal space space space space specifies specifies specifies specifies space space space space between between between between each each each each column
specifies specifies specifies specifies horizontal horizontal horizontal horizontal position position position positionofofofthe ofthe the the layout, layout, layout, layout, available available available available in ininthe in the the the layout layout layout layout container
container. row=integer row=integer row=integer row=integerwhich which which which extends extends extends extends to totothe to the the the right
IfIfIfomitted, If omitted, omitted, omitted, itititit rows=integer rows=integer rows=integer rows=integer specifies specifies specifies specifies the the the the current current current current row row row row position position position position in ininthe in the the the gridded gridded gridded griddeddefaults defaults defaults defaults to toto0
to 0.0.0. specifies specifies specifies specifies fixed fixed fixed fixed number number number number ofofofrows ofrows rows rows in ininthe in the the the layout
layout.IfIfIfIf height=dimension height=dimension height=dimension height=dimension layout
specifies specifies specifies specifies vertical vertical vertical verticalheight height height height of ofofthe ofthe the the region region region region and andand and isisisis omitted, omitted, omitted, omitted, the the the the number number number number of ofofregions ofregions regions regions created created created created in ininthe in the the they=dimension y=dimension y=dimension y=dimension vertical vertical vertical vertical direction direction direction direction isisisused
is used
used. row_span=integer row_span=integer row_span=integer row_span=integer restricted restricted restricted restricted by byby by the the the the layout layout layout layout dimensions
dimensions. IfIfIfomitted, If omitted, omitted, omitted,specifies specifies specifies specifies vertical vertical vertical verticalposition position position position of ofofthe of the the the layout, layout, layout, layout, which which which which specifies specifies specifies specifies the the the the number number number number of ofofrows ofrows rows rows that that that that the the the the region region region region itititdefaults defaults itdefaults defaults to totothe to the the the maximum maximum maximum maximum vertical vertical vertical vertical space space space space row_heights=(dimension-1 row_heights=(dimension-1 row_heights=(dimension-1 row_heights=(dimension-1 ………dimension-n) …dimension-n) dimension-n) dimension-n)extends extends extends extends down
down.IfIfIfomitted, If omitted, omitted, omitted, itititdefaults defaults itdefaults defaults to totothe to the the the will will will will occupy
The The The The default default default defaultvalue value value value isisis1
is 1.1.1
available available available available in ininthe in the the the layout layout layout layout container
container. specifies specifies specifies specifies height height height height of ofofeach ofeach each each row
current current current current vertical vertical vertical vertical position position position position on on onon the the the the page
Restricted by the layout dimensions. If omitted, x=dimension specifies horizontal position of the layout, which extends to the right. If omitted, it defaults to 0. y=dimension specifies vertical …
One of the more recent destinations, ODS Excel, became production in the third maintenance release for SAS 9.4 (TS1M3). This destination enables you to generate native Microsoft Excel formatted files, and it provides the capability to generate worksheets that include graphics, tables, and text.
The SAS® Output Delivery System provides the ability to generate output in various destination formats (for example, HTML, PDF, and Excel). One of the more recent destinations, ODS Excel, became production in the third maintenance release for SAS 9.4 (TS1M3).
In SAS, pages are arranged in layout containers and region containers. Titles and footnotes can be placed in layout containers or region containers. SAS supports two types of layout, absolute and gridded. Absolute layout enables you to specify an exact page location using x and y coordinates.
The ODS PROCLABEL statement is used to modify the table-of-contents text that is generated by the procedure name. In this example, the text The Print Procedure (generated by the two PROC PRINT steps) is modified to Detail Report of Males and Detail Report of Females, respectively.