Ods Layout Tip Sheet Sas

1679841743
Ods layout tip sheet sas

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

Summary

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 pdf
options
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
Layout
ods
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 pdf
ods 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 Sheet
Common
Common
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=dimension
in
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_major
indicates
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
horizontal
integer
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=dimension
indicates
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=dimension
all
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
isisisis
style=
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=integer
which
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
gridded
defaults
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
the
y=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 …

Download Now

Documemt Updated

Popular Download

Frequently Asked Questions

What is ods excel in sas?

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.

What is the output delivery system in sas?

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).

How are pages arranged in sas?

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.

What is the ods proclabel statement?

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.