Date:         Sun, 29 Mar 1998 14:57:30 -0600
Reply-To:     drewspen@imagin.net
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Kent Andrew (Drew) Spencer" <drewspen@IMAGIN.NET>
Organization: ImagiNet Communications
Subject:      notes from SUGI 23 an mddb presentation
Content-Type: text/plain; charset=us-ascii

sas mddb and processing large files
 
using sas outside the eis software
 using sas within base sas programs
 
what is an mddb
 a multi-dimensional database
 a lot of people say it is very much like proc summary
  more ore than that
  ability to specify class, analysis, and statistic variables
  the detail is gone, even though it seem like it is there
 eight standard statistics you get by default
  thirteen more additional ones
 con consist of several different levels of roll-ups
 this presentation will concentrate on proc mddb
 very expensive for the mddb server for the 111k it occupies
  more on the way
 'command line' options
  Out= - create a new mddb
  data= - source sas data set
  in= - the existing mddb
  label= -
 statements
  class variables / options...
   you have multiple ones
  Hierarchy variables
   one of these
  var variables / options (statistics)
   multiple ones
 lives in a sas library
  open it ins an interactive view window
   see a column only cross tab of the data
  open it in an interactive var window
  get a window asking you want you want to display
   created with af data tables
 can be moved with cports, remote library services, etc.
  remember that all processing is dons on the local workstation
  holap extension allows for intelligent processing on multiple
platforms
   written by a guy in Europe
   processing occurs on whichever server the data resides
   have to request this optional extension from sas
 sassfio engine
  allows us to go into an mddb and pick a hierarchy, viewing that
hierarchy as a read only sas data set
 
  example:
   libname mddb sassfio '...';
   proc contents data=mddb._all_;
   run;
   proc print data=mddb.gender;
   data new;
    set mddb.gender(keep=...);
   run;
 mddb's are generally smaller and more efficient than sas data sets
 sas dictionary tables can be used with mddb's
 
 
//-----------------------------
// Kent Andrew (Drew) Spencer
// DrewSpen@Imagin.Net
// http://www.imagin.net/~drewspen
// http://www.jjt.com/ntsug