Chapter Contents
Previous
Next
SAS/MDDB Server Administrator's Guide

Stored and Derived Statistics

When you create an MDDB, you have to decide which statistics should be stored with the MDDB. The statistics that can be stored with an MDDB are a minimum sufficient set that can be used to calculate other statistics when the MDDB is accessed. You can specify up to eight statistics for each analysis variable to be stored with the MDDB:

Depending on which of the eight statistics are stored, up to 13 additional statistics can be calculated by SAS/MDDB Server software at run time, allowing for up to 21 available statistics. The following table indicates which statistics can be derived and which stored statistics are required:

Stored and Derived Statistics
Statistic Required Stored Statistics
NMISS NMISS
SUMWGT SUMWGT (available only if a WEIGHT is specified)
SUM SUM (However, if a WEIGHT is specified, then SUM is the weighted sum.)
AVG N, SUM (However, if a WEIGHT is specified, then SUMWGT and SUM are required instead.)
UWSUM UWSUM
MIN MIN
MAX MAX
USS USS
RANGE MIN, MAX
PCTN N
PCTSUM SUM
CSS N, SUM, USS (However, if a WEIGHT is specified, then SUMWGT, SUM, and USS are required instead.)
VAR, STD, STDERR, CV, T, PRT, LCLM, UCLM N, SUM, USS (However, if a WEIGHT is specified, then SUMWGT is also required.)

See VAR Statement for details on specifying a WEIGHT and using the SUMWGT statistic.


Chapter Contents
Previous
Next
Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.