| SAS/MDDB Server Administrator's Guide |
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.
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
