I have done fine classing and coarse classing on the required set of variables. From which I have gathered the outputs.
I want to know how can I convert this dataset into a new one that will consist of the values and the corresponding WOE's. (I have both missing values and outliers included).
e.g from course classing I have the file for a variable (Say income) that contains:
Min_Val Max_Val NoObs RESP NRESP TOT_RESP TOT_NRESP WOE IV
. . 2321 764 1233 11170 22000 .0321 .011687
0.3 2.6 6000 2000 3000 11170 22000 .0632 .06140
I think I need a file that should contain
Income income_WOE
not sure how to do this conversion.
Thanks @LinusH. I have already calculated the WOEs for both categorical and continuous variables. But wondering, how to do the variable transformation for further analysis. Even I am not sure on the next step.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.