Results: RapidModellerHappy.sas

Model Summary

Data

The PRINT Procedure

Data Set EMWS1.REPORTER_DATASUM

Property Value
Input Data Source MYLIB.INDIA
Target Variable Respondents are very happy
Event Level VERY HAPPY
Observations 1581
Original Variables 40
Selected Variables 19

Model Summary

Target: Respondents are very happy

The PRINT Procedure

Data Set EMWS1.REPORTER_TARGETSUM

Value CODE Count Data Percentage VERY HAPPY LESS THAN VERY HAPPY
VERY HAPPY 0 544 0.34518 2.89706 0.00000
LESS THAN VERY HAPPY 1 1032 0.65482 0.00000 1.52713

Model Summary

Variable Summary

The PRINT Procedure

Data Set EMWS1.REPORTER_VARSUM

Role Level Original Count Selected Input Count
ID Interval 1 0
ID Unary 1 0
Input Binary 7 3
Input Interval 2 2
Input Nominal 25 14
Rejected Binary 2 0
Rejected Nominal 1 0
Target Binary 1 0

The SGRENDER Procedure

The SGRender Procedure

The SGRender Procedure

The SGRENDER Procedure

The SGRender Procedure

The SGRender Procedure

The SGRENDER Procedure

The SGRender Procedure

The SGRender Procedure

The SGRENDER Procedure

The SGRender Procedure

The SGRender Procedure

Variable Attribute Importance and Crosstabulations

The TABULATE Procedure

Cross-tabular summary report

Table 1

  Scorecard Points Overall N Overall % Respondents are very happy
. Less than very happy Very Happy
N % N % N %
State of health (subjective) FAIR 29.00 170.00 21.49 0.00 0.00 135.00 26.16 35.00 12.87
GOOD 93.00 308.00 38.94 1.00 33.33 199.00 38.57 108.00 39.71
POOR 0.00 53.00 6.70 0.00 0.00 46.00 8.91 7.00 2.57
VERY GOOD 114.00 257.00 32.49 2.00 66.67 134.00 25.97 121.00 44.49
How often do you attend religiou LESS OFTEN 10.00 118.00 14.92 1.00 33.33 75.00 14.53 42.00 15.44
MORE THAN ONCE A WEEK 0.00 105.00 13.27 1.00 33.33 65.00 12.60 39.00 14.34
NEVER, PRACTICALLY NEVER 20.00 29.00 3.67 0.00 0.00 22.00 4.26 7.00 2.57
ONCE A MONTH 6.00 155.00 19.60 0.00 0.00 98.00 18.99 57.00 20.96
ONCE A WEEK 20.00 112.00 14.16 1.00 33.33 76.00 14.73 35.00 12.87
ONCE A YEAR 23.00 63.00 7.96 0.00 0.00 42.00 8.14 21.00 7.72
ONLY ON SPECIAL HOLY DAYS 25.00 206.00 26.04 0.00 0.00 136.00 26.36 70.00 25.74
Believe in: hell NO 0.00 252.00 31.86 1.00 33.33 177.00 34.30 74.00 27.21
YES 10.00 536.00 67.76 2.00 66.67 337.00 65.31 197.00 72.43
Meaning of religion: To make sen MAKE SENSE OF LIFE AFTER DEATH 5.00 321.00 40.58 1.00 33.33 202.00 39.15 118.00 43.38
MAKE SENSE OF LIFE IN THIS WORLD 0.00 455.00 57.52 2.00 66.67 306.00 59.30 147.00 54.04
How important is God in your lif 2 40.00 88.00 11.13 0.00 0.00 63.00 12.21 25.00 9.19
3 21.00 40.00 5.06 0.00 0.00 25.00 4.84 15.00 5.51
4 15.00 45.00 5.69 0.00 0.00 33.00 6.40 12.00 4.41
5 14.00 68.00 8.60 0.00 0.00 47.00 9.11 21.00 7.72
6 0.00 73.00 9.23 0.00 0.00 48.00 9.30 25.00 9.19
7 20.00 98.00 12.39 1.00 33.33 54.00 10.47 43.00 15.81
8 6.00 122.00 15.42 0.00 0.00 83.00 16.09 39.00 14.34
9 12.00 98.00 12.39 0.00 0.00 71.00 13.76 27.00 9.93
NOT AT ALL IMPORTANT 42.00 85.00 10.75 2.00 66.67 50.00 9.69 33.00 12.13
VERY IMPORTANT 59.00 74.00 9.36 0.00 0.00 42.00 8.14 32.00 11.76
Worries: A terrorist attack A GREAT DEAL 0.00 222.00 28.07 0.00 0.00 156.00 30.23 66.00 24.26
NOT AT ALL 18.00 101.00 12.77 0.00 0.00 66.00 12.79 35.00 12.87
NOT MUCH 52.00 137.00 17.32 1.00 33.33 77.00 14.92 59.00 21.69
VERY MUCH 25.00 225.00 28.45 2.00 66.67 153.00 29.65 70.00 25.74
Worries: A civil war A GREAT DEAL 9.00 197.00 24.91 3.00 100.00 144.00 27.91 50.00 18.38
NOT AT ALL 1.00 172.00 21.74 0.00 0.00 120.00 23.26 52.00 19.12
NOT MUCH 0.00 112.00 14.16 0.00 0.00 79.00 15.31 33.00 12.13
VERY MUCH 27.00 207.00 26.17 0.00 0.00 124.00 24.03 83.00 30.51
Worries: Government wire-tapping A GREAT DEAL 25.00 152.00 19.22 0.00 0.00 97.00 18.80 55.00 20.22
NOT AT ALL 25.00 147.00 18.58 0.00 0.00 93.00 18.02 54.00 19.85
NOT MUCH 0.00 148.00 18.71 0.00 0.00 111.00 21.51 37.00 13.60
VERY MUCH 19.00 185.00 23.39 3.00 100.00 121.00 23.45 61.00 22.43
Family savings during past year JUST GET BY 13.00 244.00 30.85 0.00 0.00 160.00 31.01 84.00 30.88
SAVE MONEY 0.00 222.00 28.07 1.00 33.33 140.00 27.13 81.00 29.78
SPENT SAVINGS AND BORROWED MONEY 17.00 103.00 13.02 0.00 0.00 73.00 14.15 30.00 11.03
SPENT SOME SAVINGS AND BORROWED 11.00 215.00 27.18 2.00 66.67 138.00 26.74 75.00 27.57
Most people can be trusted MOST PEOPLE CAN BE TRUSTED 0.00 268.00 33.88 1.00 33.33 177.00 34.30 90.00 33.09
NEED TO BE VERY CAREFUL 6.00 494.00 62.45 1.00 33.33 329.00 63.76 164.00 60.29
Age 1: LOW - 31.5 64.00 262.00 33.12 0.00 0.00 168.00 32.56 94.00 34.56
2: 31.5 - 32.5 16.00 26.00 3.29 0.00 0.00 18.00 3.49 8.00 2.94
3: 32.5 - 53.5 77.00 345.00 43.62 3.00 100.00 244.00 47.29 98.00 36.03
4: 53.5 - 54.5 113.00 19.00 2.40 0.00 0.00 9.00 1.74 10.00 3.68
5: 54.5 - 55.5 39.00 13.00 1.64 0.00 0.00 9.00 1.74 4.00 1.47
6: 55.5 - 59.5 79.00 40.00 5.06 0.00 0.00 22.00 4.26 18.00 6.62
7: 59.5 - 60.5 0.00 12.00 1.52 0.00 0.00 9.00 1.74 3.00 1.10
8: 60.5 - HIGH 93.00 74.00 9.36 0.00 0.00 37.00 7.17 37.00 13.60
Important in life: Family NOT AT ALL IMPORTANT 11.00 21.00 2.65 0.00 0.00 16.00 3.10 5.00 1.84
VERY IMPORTANT 56.00 504.00 63.72 1.00 33.33 295.00 57.17 208.00 76.47
NOT VERY IMPORTANT 0.00 34.00 4.30 1.00 33.33 24.00 4.65 9.00 3.31
RATHER IMPORTANT 7.00 231.00 29.20 0.00 0.00 181.00 35.08 50.00 18.38
How much freedom of choice and c 2 20.00 80.00 10.11 0.00 0.00 48.00 9.30 32.00 11.76
3 55.00 50.00 6.32 0.00 0.00 30.00 5.81 20.00 7.35
4 0.00 68.00 8.60 1.00 33.33 47.00 9.11 20.00 7.35
5 24.00 102.00 12.90 0.00 0.00 78.00 15.12 24.00 8.82
6 57.00 96.00 12.14 1.00 33.33 54.00 10.47 41.00 15.07
7 21.00 110.00 13.91 0.00 0.00 72.00 13.95 38.00 13.97
8 57.00 110.00 13.91 0.00 0.00 73.00 14.15 37.00 13.60
9 7.00 50.00 6.32 0.00 0.00 39.00 7.56 11.00 4.04
A GREAT DEAL OF CHOICE 119.00 24.00 3.03 0.00 0.00 10.00 1.94 14.00 5.15
NO CHOICE AT ALL 70.00 101.00 12.77 1.00 33.33 65.00 12.60 35.00 12.87
Marital status DIVORCED 45.00 22.00 2.78 0.00 0.00 12.00 2.33 10.00 3.68
LIVING TOGETHER AS MARRIED 0.00 79.00 9.99 2.00 66.67 57.00 11.05 20.00 7.35
MARRIED 5.00 559.00 70.67 0.00 0.00 365.00 70.74 194.00 71.32
SEPARATED 23.00 15.00 1.90 0.00 0.00 11.00 2.13 4.00 1.47
SINGLE 3.00 84.00 10.62 1.00 33.33 55.00 10.66 28.00 10.29
WIDOWED 32.00 32.00 4.05 0.00 0.00 16.00 3.10 16.00 5.88
Satisfaction with financial situ 2 36.00 107.00 13.53 1.00 33.33 64.00 12.40 42.00 15.44
3 49.00 72.00 9.10 0.00 0.00 48.00 9.30 24.00 8.82
4 19.00 67.00 8.47 1.00 33.33 48.00 9.30 18.00 6.62
5 71.00 106.00 13.40 0.00 0.00 58.00 11.24 48.00 17.65
6 71.00 91.00 11.50 0.00 0.00 57.00 11.05 34.00 12.50
7 0.00 98.00 12.39 0.00 0.00 72.00 13.95 26.00 9.56
8 19.00 86.00 10.87 0.00 0.00 67.00 12.98 19.00 6.99
9 90.00 32.00 4.05 0.00 0.00 17.00 3.29 15.00 5.51
COMPLETELY DISSATISFIED 36.00 95.00 12.01 1.00 33.33 63.00 12.21 31.00 11.40
COMPLETELY SATISFIED 23.00 37.00 4.68 0.00 0.00 22.00 4.26 15.00 5.51
Important in life: Leisure time NOT AT ALL IMPORTANT 15.00 110.00 13.91 0.00 0.00 82.00 15.89 28.00 10.29
VERY IMPORTANT 22.00 260.00 32.87 1.00 33.33 169.00 32.75 90.00 33.09
NOT VERY IMPORTANT 28.00 187.00 23.64 0.00 0.00 120.00 23.26 67.00 24.63
RATHER IMPORTANT 0.00 232.00 29.33 1.00 33.33 145.00 28.10 86.00 31.62
Important in life: Politics NOT AT ALL IMPORTANT 0.00 141.00 17.83 0.00 0.00 93.00 18.02 48.00 17.65
VERY IMPORTANT 44.00 168.00 21.24 1.00 33.33 105.00 20.35 62.00 22.79
NOT VERY IMPORTANT 11.00 215.00 27.18 1.00 33.33 148.00 28.68 66.00 24.26
RATHER IMPORTANT 38.00 264.00 33.38 0.00 0.00 168.00 32.56 96.00 35.29
Important in life: Religion NOT AT ALL IMPORTANT 10.00 56.00 7.08 1.00 33.33 41.00 7.95 14.00 5.15
VERY IMPORTANT 0.00 344.00 43.49 0.00 0.00 225.00 43.60 119.00 43.75
NOT VERY IMPORTANT 13.00 89.00 11.25 0.00 0.00 59.00 11.43 30.00 11.03
RATHER IMPORTANT 41.00 300.00 37.93 2.00 66.67 189.00 36.63 109.00 40.07
How well informed is respondent? 1: LOW - 115 125.00 31.00 3.92 1.00 33.33 14.00 2.71 16.00 5.88
2: 115 - 398 12.00 49.00 6.19 0.00 0.00 35.00 6.78 14.00 5.15
3: 398 - 490 53.00 37.00 4.68 0.00 0.00 18.00 3.49 19.00 6.99
4: 490 - 611 20.00 53.00 6.70 0.00 0.00 44.00 8.53 9.00 3.31
5: 611 - 1961 52.00 555.00 70.16 2.00 66.67 363.00 70.35 190.00 69.85
6: 1961 - 2205 124.00 24.00 3.03 0.00 0.00 11.00 2.13 13.00 4.78
7: 2205 - HIGH 0.00 42.00 5.31 0.00 0.00 31.00 6.01 11.00 4.04

Classification Matrix Target=Respondents are very happy

The TABULATE Procedure

Cross-tabular summary report

Table 1

  Data Role
TRAIN VALIDATE
Predicted Predicted
LESS THAN VERY HAPPY VERY HAPPY LESS THAN VERY HAPPY VERY HAPPY
Target 66.67 33.33 50.00 50.00
.
LESS THAN VERY HAPPY 89.15 10.85 75.00 25.00
VERY HAPPY 33.82 66.18 46.32 53.68

Model Fit Statistics

The PRINT Procedure

Data Set EMWS1.REPORTER_REPORTFIT

Statistic Train Validation
Sum of Frequencies 788.0000 788.0000
Misclassification Rate 0.1878 0.3236
Maximum Absolute Error 0.9872 1.0000
Sum of Square Errors 205.7911 361.9261
Average Squared Error 0.1306 0.2296
Root Average Square Error 0.3614 0.4792
Roc Index 0.8770 0.6960
Gini Coefficient 0.7540 0.3930
Kolmogorov-Smirnov Statistic 0.6190 0.3560
Kolmogorov-Smirnov Probability Cutoff 0.3100 .
Lift at 10% 2.3996 2.0107
Cumulative Lift at 10% 2.5110 1.8128
Captured Response at 10% 12.1344 9.9265
Cumulative % Captured Response at 10% 25.3959 18.1278

Model Selection based on Model Node

The PRINT Procedure

Data Set EMWS1.REPORTER_COMPAREMDL

Selected Model Model Node Model Description Target Label Train: Akaike's Information Criterion Train: Lift Valid: Lift
Y Tree3 Decision Tree (3) Respondents are very happy . 2.39957 2.01075
  Ensmbl Ensemble_Champion Respondents are very happy . 2.54458 2.04798
  Tree2 Decision Tree Respondents are very happy . 2.44448 1.93627
  Reg2 Forwards Respondents are very happy 977.906 1.67463 1.64199

Project Information

The PRINT Procedure

Data Set EMWS1.REPORTER_PROJINFO

Property Value
Name RPM
Diagram RPM1 - V10_veryhappy
Path /saswork/SAS_workF81300007A1C_odaws02-prod-us/SAS_workA9C500007A1C_odaws02-prod-us./mafrankl0/RPM
Date Created 28Nov2015:18:37:51