SAS Component Language Dictionary

VARSTAT

Calculates simple statistics for SAS table columns

Category:

Variable

Syntax
Details
Example
See Also

Syntax

rc=VARSTAT(table-id,varlist-1,statistics,varlist-2);

rc

contains the return code for the operation:

0	successful
0	not successful

Type: Numeric

table-id

is the identifier that was assigned when the table was opened. If table-id is invalid, the program halts.

Type: Numeric

varlist-1

specifies one or more numeric columns for which to create the statistics.

Type: Character

statistics

specifies one or more statistics, separated by blanks, from the table below. For more information about these statistics, see the SAS/STAT User's Guide.

Type: Character

varlist-2

specifies one or more output variables to contain the values produced by the specified statistics. The number of output variables must equal the number of columns in varlist-1 multiplied by the number of statistics.

Note: These parameters are update parameters. See Input, Output, and Update Parameters for more information. [cautionend]

Type: Numeric

Statistic		Description
CSS		sum of squares of a column's values, corrected for the mean
CV		coefficient of variation of a column's values
KURTOSIS		kurtosis of a column's values
MAX		largest value for a column
MEAN		mean of a nonmissing column's values
MEDIAN		median value for a column
MIN		smallest value for a column
MODE		value with the most rows for a column
N		number of rows on which calculations are based
NMISS		number of rows with missing values
NUNIQUE		number of rows having a unique value for a column
RANGE		range of values for a column
SKEWNESS		skewness of a column's values
STD		standard deviation of a column's values
STDERR		standard error of the mean
SUM		sum of nonmissing column values
USS		uncorrected sum of squares for a column
VAR		variance of a column's values

Details

If more than one input column is specified with more than one statistic, then each statistic is calculated on all columns before the next statistic is calculated.

Example

Calculate the maximum, mean, and minimum values for the columns I and X from the table MY.NUMBERS:

tablename='my.numbers';
length imax xmax imean xmean xmin imin 8;
 /* Declare the results as numeric. */
varname='i x';
numberid=open(tablename);
if (numberid=z0) then
   do;
      _msg_='Cannot open '||tablename;
      return;
   end;
statcode=varstat(numberid,varname,
   'max mean min',imax,xmax,imean,xmean,imin,xmin);
put 'Column X';
put xmax= xmean= xmin=;
put 'Column I';
put imax= imean= imin=;
rc=close(numberid);
return;