OLAP CUBES

OLAP CUBES is available in Statistics Base Edition.

OLAP CUBES produces summary statistics for continuous, quantitative variables within categories defined by one or more categorical grouping variables.

OLAP CUBES {varlist} BY varlist [BY...]
          
 [/CELLS= [MEAN**] [COUNT**] [STDDEV**]
          [NPCT**] [SPCT**] [SUM** ] 
          [MEDIAN] [GMEDIAN] [SEMEAN] [MIN] [MAX] [RANGE]
          [VARIANCE] [KURT] [SEKURT] [SKEW] [SESKEW] [FIRST] 
          [LAST] [NPCT(var)][SPCT(var)] [HARMONIC] [GEOMETRIC]
          [DEFAULT] [ALL] [NONE] ]


 [/CREATE [{'catname'}...] =  {GAC    } (gvarname {(gvarvalue gvarvalue)   }
           {DEFAULT  }        {GPC    }          [{(gvarvalue gvarvalue)...}])]
                              {GAC GPC} 
                              
                              --or--         
       
                              {VAC    } {(svarname svarname)}
                              {VPC    } {(svarname svarname)...}
                              {VAC VPC}



 [/TITLE =’string’][FOOTNOTE= ’string’]

 [/HIDESMALLCOUNTS [COUNT = {5      }] ]
                            {integer}

**Default if the subcommand is omitted.

This command reads the active dataset and causes execution of any pending commands. See the topic Command Order for more information.

Syntax for the OLAP CUBES command can be generated from the OLAP Cubes dialog.

Release History

Release 19.0

• HIDESMALLCOUNTS subcommand introduced.

Example

OLAP CUBES sales BY quarter by region.