Results: RapidModellerHappy.sas

Model Summary

Data

The PRINT Procedure

Data Set EMWS1.REPORTER_DATASUM

Property Value
Input Data Source MYLIB.CHINA
Target Variable Respondents are very happy
Event Level VERY HAPPY
Observations 2300
Original Variables 40
Selected Variables 18

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 1 369 0.16241 6.15718 0.00000
LESS THAN VERY HAPPY 0 1903 0.83759 0.00000 1.19390

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 6 3
Input Interval 2 2
Input Nominal 25 13
Rejected Binary 3 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 3.00 296.00 25.78 2.00 15.38 268.00 28.18 26.00 14.13
GOOD 0.00 499.00 43.47 1.00 7.69 458.00 48.16 40.00 21.74
POOR 4.00 77.00 6.71 2.00 15.38 67.00 7.05 8.00 4.35
VERY GOOD 87.00 268.00 23.34 0.00 0.00 158.00 16.61 110.00 59.78
How often do you attend religiou LESS OFTEN 43.00 58.00 5.05 1.00 7.69 49.00 5.15 8.00 4.35
MORE THAN ONCE A WEEK 34.00 6.00 0.52 0.00 0.00 3.00 0.32 3.00 1.63
NEVER, PRACTICALLY NEVER 39.00 933.00 81.27 6.00 46.15 768.00 80.76 159.00 86.41
ONCE A MONTH 65.00 13.00 1.13 0.00 0.00 12.00 1.26 1.00 0.54
ONCE A WEEK 40.00 26.00 2.26 1.00 7.69 20.00 2.10 5.00 2.72
ONCE A YEAR 62.00 20.00 1.74 0.00 0.00 19.00 2.00 1.00 0.54
ONLY ON SPECIAL HOLY DAYS 0.00 61.00 5.31 1.00 7.69 54.00 5.68 6.00 3.26
How often to you pray NEVER, PRACTICALLY NEVER 97.00 712.00 62.02 6.00 46.15 571.00 60.04 135.00 73.37
ONCE A YEAR 37.00 12.00 1.05 0.00 0.00 12.00 1.26 0.00 0.00
ONLY ON SPECIAL HOLY DAYS 106.00 29.00 2.53 0.00 0.00 26.00 2.73 3.00 1.63
LESS OFTEN THAN ONCE A YEAR 65.00 292.00 25.44 2.00 15.38 257.00 27.02 33.00 17.93
ONCE A DAY 76.00 25.00 2.18 0.00 0.00 21.00 2.21 4.00 2.17
ONLY WHEN ATTENDING RELIGIOUS SE 87.00 32.00 2.79 0.00 0.00 28.00 2.94 4.00 2.17
SEVERAL TIMES A DAY 0.00 3.00 0.26 0.00 0.00 1.00 0.11 2.00 1.09
SEVERAL TIMES EACH WEEK 83.00 15.00 1.31 1.00 7.69 11.00 1.16 3.00 1.63
Believe in: God NO 0.00 794.00 69.16 5.00 38.46 651.00 68.45 138.00 75.00
YES 11.00 212.00 18.47 2.00 15.38 180.00 18.93 30.00 16.30
Meaning of religion: To follow r DO GOOD TO OTHER PEOPLE 0.00 528.00 45.99 1.00 7.69 437.00 45.95 90.00 48.91
FOLLOW RELIGIOUS NORMS AND CEREM 5.00 139.00 12.11 4.00 30.77 121.00 12.72 14.00 7.61
How important is God in your lif 2 61.00 190.00 16.55 3.00 23.08 160.00 16.82 27.00 14.67
3 28.00 95.00 8.28 0.00 0.00 85.00 8.94 10.00 5.43
4 36.00 52.00 4.53 1.00 7.69 43.00 4.52 8.00 4.35
5 33.00 71.00 6.18 0.00 0.00 64.00 6.73 7.00 3.80
6 80.00 58.00 5.05 2.00 15.38 49.00 5.15 7.00 3.80
7 0.00 73.00 6.36 0.00 0.00 69.00 7.26 4.00 2.17
8 49.00 64.00 5.57 0.00 0.00 54.00 5.68 10.00 5.43
9 72.00 16.00 1.39 0.00 0.00 14.00 1.47 2.00 1.09
NOT AT ALL IMPORTANT 69.00 307.00 26.74 0.00 0.00 240.00 25.24 67.00 36.41
VERY IMPORTANT 99.00 28.00 2.44 1.00 7.69 19.00 2.00 8.00 4.35
Secure in neighborhood NOT AT ALL SECURE 11.00 12.00 1.05 0.00 0.00 9.00 0.95 3.00 1.63
NOT VERY SECURE 0.00 212.00 18.47 1.00 7.69 182.00 19.14 29.00 15.76
QUITE SECURE 6.00 646.00 56.27 3.00 23.08 546.00 57.41 97.00 52.72
VERY SECURE 40.00 167.00 14.55 1.00 7.69 118.00 12.41 48.00 26.09
Worries: A war involving my coun A GREAT DEAL 60.00 360.00 31.36 1.00 7.69 295.00 31.02 64.00 34.78
NOT AT ALL 0.00 79.00 6.88 1.00 7.69 67.00 7.05 11.00 5.98
NOT MUCH 38.00 379.00 33.01 5.00 38.46 327.00 34.38 47.00 25.54
VERY MUCH 92.00 160.00 13.94 1.00 7.69 119.00 12.51 40.00 21.74
Worries: A civil war A GREAT DEAL 38.00 314.00 27.35 0.00 0.00 258.00 27.13 56.00 30.43
NOT AT ALL 83.00 109.00 9.49 2.00 15.38 92.00 9.67 15.00 8.15
NOT MUCH 54.00 399.00 34.76 5.00 38.46 338.00 35.54 56.00 30.43
VERY MUCH 0.00 137.00 11.93 0.00 0.00 106.00 11.15 31.00 16.85
Employment status FULL TIME 0.00 590.00 51.39 7.00 53.85 500.00 52.58 83.00 45.11
HOUSEWIFE 30.00 94.00 8.19 1.00 7.69 72.00 7.57 21.00 11.41
OTHER 3.00 35.00 3.05 0.00 0.00 29.00 3.05 6.00 3.26
PART TIME 23.00 204.00 17.77 1.00 7.69 168.00 17.67 35.00 19.02
RETIRED 5.00 121.00 10.54 3.00 23.08 99.00 10.41 19.00 10.33
SELF EMPLOYED 39.00 33.00 2.87 0.00 0.00 28.00 2.94 5.00 2.72
STUDENTS 27.00 46.00 4.01 1.00 7.69 36.00 3.79 9.00 4.89
UNEMPLOYED 34.00 25.00 2.18 0.00 0.00 19.00 2.00 6.00 3.26
Family savings during past year JUST GET BY 16.00 417.00 36.32 5.00 38.46 352.00 37.01 60.00 32.61
SAVE MONEY 21.00 502.00 43.73 3.00 23.08 411.00 43.22 88.00 47.83
SPENT SAVINGS AND BORROWED MONEY 36.00 35.00 3.05 0.00 0.00 28.00 2.94 7.00 3.80
SPENT SOME SAVINGS AND BORROWED 0.00 115.00 10.02 3.00 23.08 101.00 10.62 11.00 5.98
Most people can be trusted MOST PEOPLE CAN BE TRUSTED 1.00 701.00 61.06 2.00 15.38 575.00 60.46 124.00 67.39
NEED TO BE VERY CAREFUL 0.00 392.00 34.15 3.00 23.08 334.00 35.12 55.00 29.89
Age 1: LOW - 31.5 9.00 292.00 25.44 3.00 23.08 239.00 25.13 50.00 27.17
2: 31.5 - 46.5 0.00 350.00 30.49 3.00 23.08 300.00 31.55 47.00 25.54
3: 46.5 - 48.5 75.00 55.00 4.79 1.00 7.69 34.00 3.58 20.00 10.87
4: 48.5 - 71.5 12.00 424.00 36.93 4.00 30.77 363.00 38.17 57.00 30.98
5: 71.5 - HIGH 90.00 27.00 2.35 2.00 15.38 15.00 1.58 10.00 5.43
Highest educational level attain COMPLETE PRIMARY SCHOOL 21.00 268.00 23.34 2.00 15.38 232.00 24.40 34.00 18.48
COMPLETE SECONDARY SCHOOL: TECHN 12.00 350.00 30.49 3.00 23.08 294.00 30.91 53.00 28.80
COMPLETE SECONDARY SCHOOL: UNIVE 0.00 251.00 21.86 4.00 30.77 210.00 22.08 37.00 20.11
NO FORMAL EDUCATION 36.00 88.00 7.67 1.00 7.69 71.00 7.47 16.00 8.70
UNIVERSITY - LEVEL EDUCATION, WI 17.00 191.00 16.64 3.00 23.08 144.00 15.14 44.00 23.91
How much freedom of choice and c 2 49.00 10.00 0.87 0.00 0.00 9.00 0.95 1.00 0.54
3 55.00 27.00 2.35 2.00 15.38 21.00 2.21 4.00 2.17
4 0.00 44.00 3.83 0.00 0.00 43.00 4.52 1.00 0.54
5 36.00 96.00 8.36 0.00 0.00 87.00 9.15 9.00 4.89
6 15.00 138.00 12.02 2.00 15.38 123.00 12.93 13.00 7.07
7 27.00 204.00 17.77 0.00 0.00 173.00 18.19 31.00 16.85
8 17.00 297.00 25.87 2.00 15.38 253.00 26.60 42.00 22.83
9 44.00 115.00 10.02 0.00 0.00 83.00 8.73 32.00 17.39
A GREAT DEAL OF CHOICE 52.00 140.00 12.20 0.00 0.00 98.00 10.30 42.00 22.83
NO CHOICE AT ALL 11.00 11.00 0.96 0.00 0.00 9.00 0.95 2.00 1.09
Satisfaction with financial situ 2 10.00 26.00 2.26 0.00 0.00 25.00 2.63 1.00 0.54
3 3.00 68.00 5.92 0.00 0.00 64.00 6.73 4.00 2.17
4 0.00 110.00 9.58 2.00 15.38 102.00 10.73 6.00 3.26
5 35.00 179.00 15.59 4.00 30.77 159.00 16.72 16.00 8.70
6 12.00 165.00 14.37 2.00 15.38 152.00 15.98 11.00 5.98
7 84.00 229.00 19.95 0.00 0.00 186.00 19.56 43.00 23.37
8 87.00 224.00 19.51 0.00 0.00 170.00 17.88 54.00 29.35
9 102.00 65.00 5.66 0.00 0.00 36.00 3.79 29.00 15.76
COMPLETELY DISSATISFIED 14.00 18.00 1.57 2.00 15.38 14.00 1.47 2.00 1.09
COMPLETELY SATISFIED 45.00 39.00 3.40 0.00 0.00 22.00 2.31 17.00 9.24
Important in life: Politics NOT AT ALL IMPORTANT 22.00 84.00 7.32 0.00 0.00 70.00 7.36 14.00 7.61
VERY IMPORTANT 23.00 121.00 10.54 0.00 0.00 87.00 9.15 34.00 18.48
NOT VERY IMPORTANT 0.00 505.00 43.99 4.00 30.77 441.00 46.37 60.00 32.61
RATHER IMPORTANT 20.00 333.00 29.01 2.00 15.38 269.00 28.29 62.00 33.70
How well informed is respondent? 1: LOW - 1335 0.00 961.00 83.71 6.00 46.15 814.00 85.59 141.00 76.63
2: 1335 - HIGH 30.00 187.00 16.29 7.00 53.85 137.00 14.41 43.00 23.37

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 100.00 . 93.33 6.67
.
LESS THAN VERY HAPPY 96.32 3.68 96.64 3.36
VERY HAPPY 58.15 41.85 65.41 34.59

Model Fit Statistics

The PRINT Procedure

Data Set EMWS1.REPORTER_REPORTFIT

Statistic Train Validation
Akaike's Information Criterion 829.4330 .
Average Squared Error 0.0914 0.0993
Average Error Function 0.3020 0.3352
Maximum Absolute Error 0.9824 0.9982
Mean Squared Error 0.0975 0.0993
Sum of Frequencies 1135.0000 1137.0000
Root Average Square Error 0.3022 0.3151
Root Mean Squared Error 0.3123 0.3151
Schwarz's Bayesian Criterion 1191.9089 .
Sum of Square Errors 207.3759 225.7339
Misclassification Rate 0.1251 0.1346
Roc Index 0.8700 0.8310
Gini Coefficient 0.7410 0.6610
Kolmogorov-Smirnov Statistic 0.5800 0.5590
Kolmogorov-Smirnov Probability Cutoff 0.1000 .
Lift at 10% 3.7216 3.1135
Cumulative Lift at 10% 4.2860 3.9724
Captured Response at 10% 18.4783 15.6757
Cumulative % Captured Response at 10% 42.9348 40.0000

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 Reg3 Backwards Respondents are very happy 829.433 3.72159 3.11351
  Ensmbl Ensemble_Champion Respondents are very happy . 3.28375 3.32824
  Reg5 Stepwise Respondents are very happy 813.230 3.40704 3.18708
  Reg2 Forwards Respondents are very happy 852.189 3.52958 3.26277

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:30:22