MDDB Report Viewer Variables

The MDDB Report Viewer uses macro variables that are set by users and passed into the viewer when the application executes. MDDB Report Viewer Macro Variables lists and describes the macro variables.
The MDDB Report Viewer also uses global variables that you can set in the REQUEST INIT program that is used by your application server. MDDB Report Viewer Global Variables lists and describes these variables. For more information about the REQUEST INIT program, see PROC APPSRV, REQUEST Statement syntax.
MDDB Report Viewer Macro Variables
Variable Name
Description
Details
MDDB
Selected MDDB
Selected MDDB (for example, SASHELP.PRDMDDB)
METABASE
Selected metabase
Selected metabase (for example, SASHELP.MBEIS)
SR
First row to display in the table
 
NR
Number of rows to display in the table
 
D
Down
Hierarchies and category variables.
Do not create variable names that contain an embedded percent sign (%) if the percent sign precedes the following characters: 0 through 9, a through f, and A through F. Names that contain these character combinations could be misinterpreted due to encoding and decoding issues.
For example, a variable name of Product%20Line could be incorrectly interpreted as Product Line because %20 is the encoding sequence for a blank space.
AC
Across
Hierarchies and category variables.
Do not create variable names that contain an embedded percent sign (%) if the percent sign precedes the following characters: 0 through 9, a through f, and A through F. Names that contain these character combinations could be misinterpreted due to encoding and decoding issues.
For example, a variable name of Product%20Line could be incorrectly interpreted as Product Line because %20 is the encoding sequence for a blank space.
A
Analysis variable
Analysis variable. This macro variable is deprecated.
S
Statistic
Globally applied statistic. This macro variable is deprecated.
Am
Analysis variable
Analysis variable, where m designates the particular variable.
AmSn
Statistic
Statistic that is applied only to the analysis variable specified by Am. n designates the particular statistic. For example, A1S1 and A1S2 designate statistics that are applied only to the A1 analysis variable.
SV
Filter variables
Category variables to filter by
SL
Filter variable values
Values to filter by (for example, SL=COUNTRY:CANADA)
EX
Expand values
For example, EX=COUNTRY=CANADA
V
Down dimension drill-down values
For example, V=YEAR=1995
VA
Across dimension drill-down values
For example, VA=PRODTYPE= FURNITURE
ST
Display table
1=yes, 2=no
DT
Default title
Max length=200
DP
Show drill-path in title
1=yes, 2=no
DC
Show down totals
1=yes
ACB
Show across totals
1=yes
GSC
Graph source
1=3-D clickable graph, 2=standard GIF graph (SAS/GRAPH software)
GL
Graph location
1=bottom, 2=top, 3=left, 4=right
GRT
Graph type
BLOCK, HBAR, PIE, PLOT, VBAR
BS
Graph bar shapes
STAR, HEXAGON, PRISM, CYLINDER
SPDSHT
Download to Spreadsheet flag
 
GW
Graph width
Default=600, max length=4
GH
Graph height
Default=450, max length=4
SSL
Filter list box location
1=right, 2=left, 3=top, 4=bottom
SW
Filter list box width
Default=15
SH
Filter list box height
Default=3
VIEW
View Report button
Value=view report
GD
Graph down variable
Category variable for graphing
GA
Graph across variable
Across variable for filtering graph values
GG
Graph group variable
Graph group-by variable, second innermost down variable
GSG
Graph subgroup variable
Graph subgroup-by variable, third innermost down variable
SD
Down variable
Same as D, needed for Filter FORM
SAC
Across variable
Same as AC, needed for Filter FORM
CLASS
WEBEIS class name
For subclassing, default is SASHELP.WEBEIS.WEBEIS.CLASS
CSS
Style sheet URL
Applies to Variable Selection and Report pages
CSST
Toolbar style sheet URL
Applies to toolbar frame; if not specified, uses CSS value
BG
Background color or image
Color name, hexadecimal value, or image URL
BGTYPE
Background type
COLOR, IMAGE
MDDB Report Viewer Global Variables
Variable Name
Description
Details
VMDOFF
Turn VERIFYMD checking off
Any nonblank character turns it off; the default is on
_GRFONT
 
SWISSB is the default; use SAS font names
_MRVHELP
URL of Help file
The default is the Hints and Tips page
_MRTBLOC
Toolbar location
1=top, 2=bottom, 3=left, 4=right, and 5=none; the default is top
_MRVSEP
Download to spreadsheet delimiter
A comma is the default
_MRVTBSC
Toolbar frame scrolling
NO or blank indicates no scrolling; YES adds a scroll bar to frame
_MRVTBSZ
Toolbar size in pixels
A character string of the form (horizontal, vertical); the default is (50, 125)
_MRNODIMBOXES
Turns off the down and across list boxes and the View Report button on display
A nonblank value turns this off; the default is on
_MRNOFRAMES
Indicates whether to use HTML frames in the output
A nonblank value turns this off; the default is on
_MRNOVARCHECK
Turns off the down and across variable selection error checking
A nonblank value turns this off; the default is on
_MRBODYONLY
Nonblank
Outputs the HTML between the <BODY> and </BODY> tags on the Layout and the Report pages
_MRVFRAMESET
Enables you to specify a custom <FRAMESET> tag on the Report page
 
_MRVNOPGOP
Nonblank
Turns off the paging feature
_MRVRNDX1
Value for the radio button that represents the first number of rows
The default is All
_MRVRNDX2
Value for the radio button that represents the second number of rows
The default is 25
_MRVRNDX3
Value for the radio button that represents the third number of rows
The default is 50
_MRVRNDX4
Value for the radio button that represents the fourth number of rows
The default is 100
_MRVNRLKS
Minimum number of paging lines to display beneath the report table
The default is 5
_MRNOSORT
Turns off the sorting feature
A nonblank value turns this off; the default is on
_MRTBLPRM
Sets report <TABLE> tag parameters
For example, "CELLPADDING=4 CELLSPACING=2 BORDER=3"
Copyright © SAS Institute Inc. All rights reserved.