Obtain descriptive statistics for a single variable.
Proc UNIVARIATE requires that the input data be in tab separated value (tsv) format. This format for data is used by all EZ-R Stats procedures. The primary use of proc UNIVARIATE is to determine the characteristics of a population in order to determine what further testing and analysis is required.
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 Univariate provides the following statistics for the researcher/auditor:
- Number of observations in the population
- Median value
- Mode value
- Percentiles as follows- 1,5,10,25,50,75,90,95,98,99
- Top 5 values (largest) (with position in file)
- Bottom 5 values (smallest) (with position in file)
- Quartiles
- Range
- Mean
- Variance
- Standard Deviation
- Minimum Value
- Maximum value
- Sum of Squares
- Skewness
- Kurtosis
- Number of observations equal to zero, less than zero and greater than zero
- Number of missing observations
- Corrected Sum of Squares
- Uncorrected Sum of Squares
- Standard Error of the Mean
Sample Screen Shot
Syntax (Batch Script processing)
proc univariate data=DATAFILE;
var VARIABLENAME;
out = OUTPUTRESULT;
Parameters Used
There are three parameters for Proc Univariate:
DATAFILE - the datafile to be analyzed
VARIABLENAME - the numeric variable to be analyzed
OUTPUTRESULT - name of the file to store the results of the analysis
Example Script
*;
* uni2.ezs;
* obtain univariate statistics on census data;
libname census '{%libin}';
libname uni '{%libout}';
proc univariate data=census.censuspart1;
out = uni.uni2;
var V0302000;
run;
Analysts interested in Proc Univariate may also be interested in Proc Means, Proc Outlier, Proc Sort and Proc Benford .
View screen shots of the system.
There is also a web analytics version which can be run directly from the Internet using Excel or other data source (in tab separated value format). View Web Analytics details. All software is provided at no cost.
 |
|
Web Page last updated on 10-03-07 © EZ-R Stats, LLC 2005-2007 |
© EZ_R Stats
Visit EZ_R Stats on the web at:
www.ezrstats.com