Date:         Tue, 9 Dec 1997 08:34:38 +0200
Reply-To:     Howard Wright <hwright@OLDMUTUAL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Howard Wright <hwright@OLDMUTUAL.COM>
Subject:      Re: Suppression of Statistical Labels in EIS Multidimensional
Comments: To: Patricia E Holanek <patricia.e.holanek@CCMAIL.CENSUS.GOV>
Content-Type: text/plain; charset=us-ascii

Hi Pat,
 
What you need to do is override the application's model with the
following code.  You do this by going to Advanced --> Methods.  Select
Model and click on _SET_APPLICATION_ in the list box.  Set 'When to Run'
to 'Overide' (the default) and enter the location where you want your
SCL code to be stored and the code's label (I have used 'MDBVSETA').
Then click on 'Edit'.  Type in the following code:
 
length _self_ _frame_ 8 _method_ $40;
MDBVSETA:
 method appllist rc
8;
 
rc=insertc(appllist,'MULTIVAL',-1,'STATS_display_status');
  call
super(_self_,'_SET_APPLICATION_',appllist,rc);
    /* The following code is just an illustration of what else you can
do here */
  viewer=getnitemn(_self_,'VIEWERID');
    /* Sets the Table background color */
  call send(viewer,'_SET_BACKGROUND_COLOR_','WHITE');
    /* Sets the data background to a nice pastel yellow color - better
than a boring white or grey */
  call
send(viewer,'_SET_DATA_BACKGROUND_COLOR_','CXFFFFEF');
 
endmethod;
return;
 
Compile it and run.  The stats header should be gone!
 
Patricia E Holanek wrote:
>
>      Situation:  In an EIS multidimensional report I have been trying
>      to suppress the statistical label line when there are more than
>      one statistic used.  We would like the report to have four columns of
>      data where the first three columns would have only the SUM
>      statistical data and no statistical label name (or column header of),
>      SUM, above the columns of data; and where the fourth column would have
>      only the MAX statistical data and also no statistical label name (or
>      column header of), MAX, above the fourth column of data.
>      (What triggered the approach of using two statistics to begin with is
>      that the fourth column has dates listed.  We wanted the maximum dates
>      within the hierarchy and not the sum of the dates.  The date in the
>      column is formatted as mm/dd/yyyy.  For example, 02/11/98.)
>
>      Thanks in advance,
>
>      Pat Holanek
>      DOD/BOC/DMD
>
>      SAS Information:
>      SAS 6.12
>
>      Operating System Info:
>      WIN95
 
--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Howard Wright                +               InfoActive CC +
+ SAS Consultant               +       A SAS Quality Partner +
+ Cape Town                    + On assignment at Old Mutual +
+ South Africa                 +++++++++++++++++++++++++++++++
+ Cell        (083) 270-7511                                 +
+ Old Mutual  (021) 509-4118         hwright@oldmutual.com   +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ There is no relationship whatsoever between the above      +
+ views and those of Old Mutual.                             +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++