Proc Summary
40+ easy to perform tests
Proc summary can be used to obtain basic statistics about variables in a file. These statistics include the sum, minimum value, maximum value and record count for each variable. Output is to tab separated file which can then be processed further, if desired. Processing can be done using electronic work papers with input from an Excel work sheet.
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.
Only a single variable is summarized. However, up to five sort columns may be specified, in order to obtain statistics at the control break level, i.e. “BY” values. Note that the file does not need to be sorted in BY variable sequence before proc summary can be run.
The many uses for PROC SUMMARY include verifying file totals, obtaining basic population statistics, identifying sampling parameters, establishing control totals, etc.
Example usage:
Click the "Run" button to run the summary.
Results can be pasted back into Excel:
More detail information is available in the user guide.
There are over 40 procedures available in total.