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 10: Performing a Multi-Dimensional Summary
Details
This PROC IMSTAT example
demonstrates creating multi-dimensional summaries of the Prdsale data
set. Three set specifications are shown in the example. There is no
limit to the number of set specifications that you can specify.
Program
libname example sasiola host="grid001.example.com" port=10010 tag='hps';
data example.prdsale; set sashelp.prdsale; run;
proc imstat data=example.prdsale;
mdsummary actual / 1
/* 1 */ groupby=(region prodtype)
formats=("$", "$")
filter="(NOT (REGION='WEST'))",
/* 2 */ groupby=(region prodtype division)
formats=("$", "$", "$")
filter="(NOT (REGION='WEST')) AND (NOT (PRODUCT='SOFA'))"
/* 3 */ groupby=(region prodtype division year)
formats=("$", "$", "$", "f4.") 2
filter="(NOT (REGION='WEST'))";
run;Program Description
-
This MDSUMMARY statement uses the variable that is named actual. You can analyze more than one variable by adding the variable names before the slash.
-
Formats are enclosed in quotation marks and separated by commas. Numeric formats are also enclosed in quotation marks.
Output
Results for Summarization of Actual by Region and Prodtype
Results for Summarization of Actual by Region, Prodtype, and
Division
Results for Summarization of Actual by Region, Prodtype, Division,
and Year
Copyright © SAS Institute Inc. All Rights Reserved.