About JinboZhao

JinboZhao · ‎08-17-2017

Thank you again. While, could you give some possible ways to fix it in SAS base or SAS E-Guide? I really have no clue, becuase this variable is alreay integer in the original dataset.

JinboZhao · ‎08-17-2017

Thank you. You are right, in the first one, DAYS is Nominal level variable, but in the second one, it is the Interval level variable. Could you tell me how to change the variable's Level?

JinboZhao · ‎08-17-2017

Hi, I used SAS Enterprise Miner to generate a scorecard. For one variable in the scorecard, DAYS, it has all the discrete integer values from 1 to 31. It's WOE is like the follow table: Value Group Cutoff EventCount Non Event Count Total Event Rate WOE _MISSING_ 1 0 0 0 0 0 _UNKNOWN_ 1 0 0 0 0 0 1 1 693 143 836 0.829 0.67349 8 2 188 28 216 0.87 0.34743 13 3 76 7 83 0.916 -0.1332 22 3 142 11 153 0.928 -0.3063 15 4 267 15 282 0.947 -0.6275 16 4 130 5 135 0.963 -1.0064 19 5 92 3 95 0.968 -1.1715 23 5 123 2 125 0.984 -1.8674 29 5 81 1 82 0.988 -2.1428 When I used another dataset to run the Interactive Grouping node, I got a continuous groups for the same DAYS variables as in the following table. Those two datasets are using exactly the same variables, only different values, because they represent two time's data. Value Group Cutoff EventCount Non Event Count Total Event Rate WOE _MISSING_ 1 0 0 0 0 0 _UNKNOWN_ 1 179 22 201 0.891 0.28689 1<=DAYS<7 1 179 14 193 0.927 -0.1651 7<=DAYS<10 2 195 9 204 0.956 -0.6925 10<=DAYS<25 3 172 14 186 0.925 -0.1252 25<=DAYS<31 4 118 7 125 0.944 -0.4415 I do not want this value showing in interval groups. I need them in descrete values. I tried to split those 5 old interval groups into 31 interval groups, so that each group only has one integer value. But the problem is, Miner assign new groups with a numerical order. Like, less than 7 in group 1, DAYS between (7, 10) in group 2, but DAYS>21 (DAYS=21) can not be assign to group 1 again. This is not what I want. Is there method to change it to the discrete values group, like in the first example? Thank you.

JinboZhao · ‎08-17-2017

Hi SAS, I used SAS Enterprise Miner to generate a scorecard, then I got the corresponding logistic regression. My regression result is as follows: Event Classification Table Data Role=TRAIN Target=TARGET Target Label=' ' False True False True Negative Negative Positive Positive 16 31 384 3928 Then I output the regression generating code and opened it in SAS base. I run it on the same dataset. This time I got the frequency table of my old and new predicted target: Table of TARGET by U_TARGET U_TARGET(Unnormalized Into: TARGET) Total 1 TARGET 415 415 0 Frequency 1 Frequency 3944 3944 4359 4359 Total Frequency It gave a totally different result with the one from E-Miner. I do not know why, and I doubt of the accuracy of the result from E-miner. Could anyone give me some clue? Thank you.

JinboZhao · ‎08-15-2017

Thank you for your answer. My problem is that I got my logistic regression in SAS Enterprise Miner under the REGRESSION node. It generated SAS scoring code for regression, but it is not a model which I can use to imput and then test on other dataset. Do you know how to use the Regression Scoring Code to generate the respectively SAS model dataset? Thank you.

JinboZhao · ‎08-14-2017

Hi Reeza, I used the SCORE node, but it did not give me statistical parameters like ROC, KINI on the new dataset.

JinboZhao · ‎08-14-2017

Hi, I used SAS Enterprise Miner and generated a scorecard sample and the logistic regression respectively.I want to do the out-of-time test on a new testing dataset. I tried to use SCORE node, I got a list of predicted percentage of good/bad. But I did not get any statistical comparison, like ROC, KINI, KS. I want to get those statistical parameters to test the reliability of my scorecard model. I was suggested that Somer's D is similar as KINI, which one I can easily get from SAS. However, based on my research, I only saw some articles online which gives information about how to generate a logistic regression and also the Somer'D on the same dataset, not on another test dataset. Could anyone give me some clue? Thank you.

JinboZhao · ‎08-10-2017

Hi, I have a dataset like the following. I would like to format all those numeric values to no decimals. Like -8 -4 4 for the first line. But after I used the Proc Format, all the negative numbers are missing. Could you help me? char1 char2 char3 -8.00000 -4 4.00 -8.00000 -4 14.00 6.00000 8 4.00 -1.00000 3 4.00 6.00000 3 14.00 6.00000 0 4.00 6.00000 0 4.00 11.00000 3 4.00

JinboZhao · ‎08-03-2017

Hi SAS, I tried to run INTERACTIVE GROUPING node in SAS Miner since today afternoon, but it cannot be run. No result generates either. It shows a red false icon. I can use it in the morning, but suddenly can not run any result. Could you help me?

JinboZhao · ‎08-01-2017

Thank you very much. The exercise code works well in my SAS. It should work on my data.

JinboZhao · ‎08-01-2017

Hi, sorry to reply you so late. This code does not work well on my SAS, it always say, the FILE WORK.HAVE.DATA does not exist. I could not find the reason, could you help me? Thank you.

JinboZhao · ‎07-24-2017

Hi, after I tried, it shows ! -9999997.00 = 'Large neg' _____________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 26 other ='other'; Could you give me further suggestion?

JinboZhao · ‎07-24-2017

Hi SAS, I have a table with over 20 variables, for each variable it contains many same values like -9999997.00. I want to use some coding to count the frequency of this value in each variable. I can do once a time use proc freq data=want (where=(var1=-9999997.00)); tables var1/out = want1; run; But it is time-consuming to duplicate this process all the time. Could anyone give some clue to slove it easier? Thank you. The following is part of my dataset: Var1 Var2 Var3 Var4 Var5 Var6 Var7 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 25.0 155.00 125.00 2.00 2758 1650 1.93 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 25.0 443.00 443.00 1.00 5349 4233 4.48 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 25.0 174.00 174.00 1.00 3499 3429 1.18 25.0 7.00 7.00 1.00 28 15 0.29 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 25.0 240.00 210.00 1.00 1114 2700 24.91 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 25.0 104.00 104.00 1.00 1092 1048 3.01 25.0 104.00 104.00 1.00 1092 1048 3.01 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 25.0 130.00 130.00 1.00 3275 3246 2.43 25.0 68.00 68.00 0.00 2087 125 9.42 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00 -9999997.0 -9999997.00 -9999997.00 -9999997.00 -9999997 -9999997 -9999997.00

JinboZhao · ‎07-21-2017

Hi SAS, I have a data set which contains over 30 character and numeric variables. Based on this dataset, I generate a scorecard. Now, I want to replace each variable's value with the score I got. Here is part of my dataset: ID DAYS GRADE REMAINING_PERIOD 1 5 2A 5.23 2 6 2C 10.95 3 8 2D 20.22 4 3 1C . 5 4 2B 8.66 Here is part of my scorecard: Variable Group Lable Scorecard Points DAYS 2 2<= DAYS< 5 12 DAYS 3 5<= DAYS< 6 -4 DAYS 4 6<= DAYS< 9 7 GRADE 1 2A, 2C, 3A 6 GRADE 2 2D 55 GRADE 3 1C, 2B, 3B, _MISSING_, _UNKNOWN_ 6 GRADE 4 0, 4 8 REMAINING_PERIOD 3 4.66<= REMAINING_PERIOD< 9.28 13 REMAINING_PERIOD 4 9.28<= REMAINING_PERIOD< 11.65 18 REMAINING_PERIOD 5 11.65<= REMAINING_PERIOD< 23.32, _MISSING_ 9 The below one is the result I want to generate: SCORE TABLE ID DAYS GRADE REMAINING_PERIOD 1 -4 6 13 2 7 6 18 3 7 55 9 4 12 6 9 5 12 6 13 I can do it using DATA, IF, ELSE IF, ELSE, RUN. But since I have more than 150 groups in my scorecard, it is really a time-consuming work. Could any expert suggest me an easier and time-consuming way? I am thing maybe I can use some REPLACE procedure, but not familiar with it. Could you help me?

JinboZhao · ‎07-20-2017

Hi SAS, I have a data set with a target variable which only contains 1 and 0, and other about 60 independent numeric variables. For each variable, I would like to bin them into 10 same width groupds, and then count the frequency of target numbers in each group. For example, variable INCOME, INCOME TARGET 0 0 0 1 1 0 22 0 35 0 100 0 150 0 188 0 207 0 248 0 280 0 293 0 330 0 340 0 380 0 400 0 445 0 520 0 580 0 650 0 700 0 865 0 900 0 1000 0 1062 0 1200 0 1215 0 1400 0 1560 0 1600 1 1700 0 The bin: BIN 0 0-170 170 170-340 340 340-510 510 510-680 680 680-850 850 850-1020 1020 1020-1190 1190 1190-1360 1360 1360-1530 1530 1530-1700 1700 The table I want to have finally: INCOME COUNT TARGET_1 TARGET_0 0-170 7 1 6 170-340 8 0 8 340-510 3 0 3 510-680 3 0 3 680-850 1 0 1 850-1020 3 0 3 1020-1190 1 0 1 1190-1360 2 0 2 1360-1530 1 0 1 1530-1700 3 1 2 I can do it step by step, like bin them in EXCEL, then replace the INCOME with bins value, then count the numbers . But I do not know how to do them in SAS step by step. Also, I have more than 60 numeric variables, is there any easier way to deal them in SAS? Many appreciation.

Online Status	Offline
Date Last Visited	‎08-23-2017 06:02 AM

Re: SAS Miner WOE change interval groups to discrete integer groups

Re: SAS Miner WOE change interval groups to discrete integer groups

SAS Miner WOE change interval groups to discrete integer groups

Different regression result on same dataset from both Enterprise Miner...

Re: Out-of-time Logistic regression test

Re: Out-of-time Logistic regression test

Out-of-time Logistic regression test

How to format negative numbers?

SAS Miner INTERACTIVE GROUPING stop run

Re: DATA REPLACE VALUES WITH SCORES

Re: SAS Miner WOE change interval groups to discrete integer groups

Re: SAS Miner WOE change interval groups to discrete integer groups

SAS Miner WOE change interval groups to discrete integer groups

Different regression result on same dataset from both Enterprise Miner...

Re: Out-of-time Logistic regression test

Re: Out-of-time Logistic regression test

Out-of-time Logistic regression test

How to format negative numbers?

SAS Miner INTERACTIVE GROUPING stop run

Re: DATA REPLACE VALUES WITH SCORES

Re: DATA REPLACE VALUES WITH SCORES

Re: Count specific values frequency for each variable in one dataset

Count specific values frequency for each variable in one dataset

DATA REPLACE VALUES WITH SCORES

Bin numeric variable and count them