_DISPLAY_VALUES_ Method

Outputs the numerical values to the report table
Syntax
Details
Example

Syntax

CALL SEND(OBJID,'_DISPLAY_VALUES_',row-list,column-list, actions-list,metabase-id,
viewreport-flag,_url,_argument-string, _argument-string2,initial-url,analysis-variable,
statistic-variable, across-variable,background-type,background-value,title,webcls,dlflag);

Required Arguments

row-list
the row list from EMDDB_M.
Type:Numeric
column-list
the column list from EMDDB_M.
Type:Numeric
actions-list
the actions sublist that determines drill-down.
Type:Numeric
metabase-id
the metabase ID number.
Type:Numeric
viewreport-flag
the View Report button flag.
Type:Numeric
_url
the URL of the next query.
Type:Character
_argument-string
the argument string for the next query.
Type:Character
_argument-string2
the argument string for the next query.
Type:Character
initial-url
the URL of the initial HTML page.
Type:Character
analysis-variable
the analysis variable to graph.
Type:Character
statistic-variable
the statistic to graph.
Type:Character
across-variable
the analysis variable to graph.
Type:Numeric
background-type
the background type (IMAGE or COLOR). This value is optional.
Type:Character
background-value
the background value. This value is optional.
Type:Character
title
the HTML page title.
Type:Character
webcls
the WEBEIS class name.
Type:Character
dlflag
a flag that indicates whether to download the table to a spreadsheet, where 0=output HTML tags with data values and 1=output data values with spreadsheet delimiters.
Type:Numeric

Details

This method
  • calls the _GET_DATA_ATTR_ method of the METABASE class to get the base table name for reach-through
  • calls the _GET_EXPANDABLE_CLASS_ method of the data model to get the expand variable
  • calls the EMDDB_M _SET_ACTIVE_VALUE_ method
  • calls the EMDDB_M _SET_ACTION_STATUS_ method to validate drill-down
  • outputs the class value for the current row
  • outputs an <A> tag if drill-down is valid
  • outputs the expand link if the expand is valid
  • outputs the collapse link if the collapse is valid
  • calls the EMDDB_M _GET_VALUES_ method to get the numerical value of the current statistic/analysis pair
  • calls the _GET_ANALYSIS_VAR_NAME_ method
  • calls the metabase _GET_VAR_ATTR_ method to get the variable attributes
  • calls the _GET_RANGE_COLOR_ method if a range is applied
  • calls the EMDDB_M _GET_CLASS_FORMAT_ method
  • outputs the numerical value to a table cell
  • calls the _OUTPUT_REACHTHRU_LINK_ method if the reach-through to detail is valid
  • outputs the closing HTML table tag.

Example 

rowlist=makelist();
call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','ROW',rowlist);
collist=makelist();
call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','COL',collist);
actionsl=makelist();
rc=insertc(actionsl,'',-1,'CL_DRILL');
mbid=instance(loadclass('SASHELP.MB.METABASE'));
vrflag=1;
_url='/cgi-bin/broker?_PROGRAM=sashelp.webeis.mddbrpts.scl&_SERVICE=default
&_DEBUG=0&RPTTYPE=2&GRTYPE=BLOCK';
_args='&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&DOWN=Geographic&ACROSS
=Product+Line&A=ACTUAL';
_args2='&S=SUM';
grphvar='';
grphstat='';
grphacr='PRODTYPE';
bgtype='color';
bg='yellow';
title='';
webcls='SASHELP.WEBEIS.WEBEIS';
dlflag=0;
call send(_self_,'_DISPLAY_VALUES_',rowlist,collist,actionsl,mbid,vrflag,
          _url,_args,_args2,mddblink,grphvar,grphstat,grphacr,
          bgtype,bg,title,webcls,dlflag);
The following output is produced:
<TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1>
<A href="../mddbapp.hlp/" onClick="this.href=clsurl('V11=COUNTRY=CANADA&V10=1
&_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">CANADA</A>
</TH>
<TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS
&D=Geographic&AC=Product%20Line&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=CANADA&DC=1&ACB=1&ST=1&GL=1&GSC=1
&SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic
&PAC=Product%2BLine&BGTYPE=color&BG=%23FFFFE7" TARGET="_top">
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="tdcell" BGCOLOR=#008000><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $97,864</A></TD>
<TD CLASS="tdcell" BGCOLOR=#00FFFF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $149,126</A></TD>
<TD CLASS="tcolcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA')" TARGET="_blank"> $246,990</A></TD>
<TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1>
<A href="../mddbapp.hlp/" onClick="this.href=clsurl
('V11=COUNTRY=GERMANY&V10=1&_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" 
TARGET="_top">GERMANY</A>
</TH>
<TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS
&D=Geographic&AC=Product%20Line&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=GERMANY&DC=1&ACB=1&ST=1&GL=1&GSC=1
&SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine
&BGTYPE=color&BG=%23FFFFE7" TARGET="_top">
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="tdcell" BGCOLOR=#00FFFF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> 
$101,194</A></TD>
<TD CLASS="tdcell" BGCOLOR=#00FFFF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> 
$144,804</A></TD>
<TD CLASS="tcolcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY')" TARGET="_blank"> $245,998</A></TD>
<TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1>
<A href="../mddbapp.hlp/" onClick="this.href=clsurl('V11=COUNTRY=U.S.A.&V10=1
&_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">U.S.A.</A>
</TH>
<TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE
&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&D=Geographic&AC=Product%20Line
&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=U.S.A.&DC=1&ACB=1&ST=1&GL=1&GSC=1&SSL=1
&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine
&BGTYPE=color&BG=%23FFFFE7" TARGET="_top">
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="tdcell" BGCOLOR=#008000><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DU.S.A.&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $91,567</A></TD>
<TD CLASS="tdcell" BGCOLOR=#00FFFF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DU.S.A.&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $145,782</A></TD>
<TD CLASS="tcolcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DU.S.A.')" TARGET="_blank"> $237,349</A></TD>
<TR><TH CLASS="trowlab" ROWSPAN=1 COLSPAN=1>TOTAL</TH>
<TH CLASS="trowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE
&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&D=Geographic
&AC=Product%20Line&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=TOTAL&DC=1&ACB=1&ST=1&GL=1&GSC=1
&SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine
&BGTYPE=color&BG=%23FFFFE7" TARGET="_top"&gt;
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="trowcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $290,625</A></TD>
<TD CLASS="trowcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $439,712</A></TD>
<TD CLASS="trowcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=')" TARGET="_blank"> $730,337</A></TD>
</TR></TABLE><BR><BR>
Copyright © SAS Institute Inc. All rights reserved.