PROC MEANS provides a statistical summary of each numeric column in the data. These attributes include count, min, max, mean, standard deviation, range, variance, skewness and kurtosis. The auditor can use PROC MEANS to obtain a high-level overview of the data being audited.
Use Excel for auditing and analysis ? Why not try our Analytic software for the the most common functions - Benford's Law, outliers, univariate statistics, CMA sampling, interval sampling, sample size calculation, stratification, classification, holiday date checking, duplicates, gaps, analytic review, trend analysis, credit card validation (luhn-10) etc. This desktop version operates from within Excel (an add-in). Want to learn more? Visit the Analytics home page (or view the link Operation Guide for a full description and screen shots).
PROC MEANS is a useful audit procedure to obtain a "snapshot" of the transactions or population being audited.
View summary of all audit procedures
PROC MEANS Example Screen Shot
Since no variables were specified, the statistics are gathered for all numeric variables and are shown below:
Syntax (Batch Script Processing)
proc means data=DATAFILE;
var VARIABLENAME;
out = OUTPUTRESULT;
Parameters Used
There are three primary parameters for the Means command:
DATAFILE - the datafile to be analyzed
VARIABLENAME - the numeric variable to be analyzed (if omitted, then all numeric variables are analyzed)
OUTPUTRESULT - name of the file to store the results of the analysis
Example Script
*
*;
*;
* means6.ezs;
* get means report for census data using proc means;
libname test '{%libin}';
libname res '{%libout}';
proc means data=test.censuspart1;
out = res.stats6;
run;
The Proc Means procedure is part of EZ-R Stats for Windows.
Analysts interested in Proc Means may also be interested in Proc Summary.