IMSTAT Procedure (Analytics)
- Syntax
Procedure SyntaxPROC IMSTAT (Analytics) StatementAGGREGATE StatementARM StatementASSESS StatementBOXPLOT StatementCLUSTER StatementCORR StatementCROSSTAB StatementDECISIONTREE StatementDISTINCT StatementFORECAST StatementFREQUENCY StatementGENMODEL StatementGLM StatementGROUPBY StatementHISTOGRAM StatementHYPERGROUP StatementKDE StatementLOGISTIC StatementMDSUMMARY StatementNEURAL StatementOPTIMIZE StatementPERCENTILE StatementRANDOMWOODS StatementREGCORR StatementSUMMARY StatementTEXTPARSE StatementTOPK StatementTRANSFORM StatementQUIT Statement - Overview
- Using
- Examples Calculating Percentiles and QuartilesRetrieving Box ValuesRetrieving Box Plot Values with the NOUTLIERLIMIT= OptionRetrieving Distinct Value Counts and GroupingPerforming a Cluster AnalysisPerforming a Pairwise CorrelationCrosstabulation with Measures of Association and Chi-Square TestsTraining and Validating a Decision TreeStoring and Scoring a Decision TreePerforming a Multi-Dimensional SummaryFitting a Regression ModelForecasting and Automatic ModelingForecasting with Goal SeekingAggregating Time Series DataTraining and Validating a Neural NetworkPredicting Email Spam and Assessing the ModelTransforming Variables with Imputation and Binning
Example 1: Calculating Percentiles and Quartiles
Details
If you specify the PERCENTILE
statement without variables or options, you obtain results for the
25th, 50th, and 75th percentile. These are also known as the first
quartile, the median, and the third quartile. This is done for all
numeric non-CLASS variables in the table.
This PROC IMSTAT demonstrates
the default behavior for calculating percentiles for a single variable
and then demonstrates using GROUPBY= variables and generating results
for nonstandard percentiles.
Program
libname example sasiola host="grid001.unx.sas.com" port=10010 tag='hps';
data example.prdsale; set sashelp.prdsale; run;
proc imstat data=example.prdsale;
percentile actual; 1
run;
percentile actual / groupby=(region division); 2
run;
percentile actual / values=(3 5 10 90 95 97); 3
quit;Program Description
-
This PERCENTILE statement generates the default output for the Actual variable.
-
The quartiles for the Actual variable are calculated for the groups of Region and Division.
-
The VALUES= option is used to specify the percentiles to calculate.
Output
The following results
include the column that is named Converged. This column indicates
whether the iterative percentile algorithm converged for the variable
and percentile. It is possible that some percentiles can fail to converge
while others do converge. The converged percentiles match those computed
with the UNIVARIATE or MEANS procedures using their default definition
of a quantile.
Default Output for a Single Variable
Results for Actual Grouped by Region and Division
Results for a Single Variable Using the VALUES= Option
Copyright © SAS Institute Inc. All Rights Reserved.