Logistic Regression Practical part- 3

SAS Analytics Logistic Regression- Case Study & Practical
9 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€67.18
List Price:  €95.97
You save:  €28.79
£55.86
List Price:  £79.80
You save:  £23.94
CA$97.87
List Price:  CA$139.82
You save:  CA$41.95
A$107.62
List Price:  A$153.75
You save:  A$46.13
S$94.24
List Price:  S$134.64
You save:  S$40.39
HK$544.83
List Price:  HK$778.36
You save:  HK$233.53
CHF 62.54
List Price:  CHF 89.34
You save:  CHF 26.80
NOK kr774.97
List Price:  NOK kr1,107.14
You save:  NOK kr332.17
DKK kr501
List Price:  DKK kr715.75
You save:  DKK kr214.74
NZ$119.95
List Price:  NZ$171.37
You save:  NZ$51.41
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.19
৳8,361.58
List Price:  ৳11,945.63
You save:  ৳3,584.04
₹5,909.84
List Price:  ₹8,442.99
You save:  ₹2,533.15
RM312.71
List Price:  RM446.75
You save:  RM134.04
₦118,484.88
List Price:  ₦169,271.38
You save:  ₦50,786.49
₨19,443.22
List Price:  ₨27,777.22
You save:  ₨8,334
฿2,412.28
List Price:  ฿3,446.26
You save:  ฿1,033.98
₺2,418.32
List Price:  ₺3,454.90
You save:  ₺1,036.57
B$406.01
List Price:  B$580.04
You save:  B$174.03
R1,267.89
List Price:  R1,811.35
You save:  R543.45
Лв131.37
List Price:  Лв187.69
You save:  Лв56.31
₩98,301.65
List Price:  ₩140,436.95
You save:  ₩42,135.30
₪259.10
List Price:  ₪370.16
You save:  ₪111.06
₱4,125.14
List Price:  ₱5,893.31
You save:  ₱1,768.17
¥10,832.35
List Price:  ¥15,475.45
You save:  ¥4,643.10
MX$1,429.79
List Price:  MX$2,042.64
You save:  MX$612.85
QR255.18
List Price:  QR364.56
You save:  QR109.38
P956.90
List Price:  P1,367.06
You save:  P410.16
KSh9,061.51
List Price:  KSh12,945.58
You save:  KSh3,884.06
E£3,475.01
List Price:  E£4,964.52
You save:  E£1,489.50
ብር8,566
List Price:  ብር12,237.67
You save:  ብር3,671.66
Kz63,900.87
List Price:  Kz91,290.87
You save:  Kz27,390
CLP$69,057.73
List Price:  CLP$98,658.13
You save:  CLP$29,600.40
CN¥506.93
List Price:  CN¥724.22
You save:  CN¥217.29
RD$4,217.06
List Price:  RD$6,024.63
You save:  RD$1,807.57
DA9,397.90
List Price:  DA13,426.15
You save:  DA4,028.25
FJ$159.29
List Price:  FJ$227.57
You save:  FJ$68.27
Q540.13
List Price:  Q771.64
You save:  Q231.51
GY$14,638.82
List Price:  GY$20,913.50
You save:  GY$6,274.67
ISK kr9,776.20
List Price:  ISK kr13,966.60
You save:  ISK kr4,190.40
DH703.91
List Price:  DH1,005.63
You save:  DH301.72
L1,275.33
List Price:  L1,821.98
You save:  L546.64
ден4,132.76
List Price:  ден5,904.20
You save:  ден1,771.43
MOP$561.01
List Price:  MOP$801.48
You save:  MOP$240.46
N$1,268.91
List Price:  N$1,812.81
You save:  N$543.90
C$2,574.70
List Price:  C$3,678.31
You save:  C$1,103.60
रु9,449.77
List Price:  रु13,500.25
You save:  रु4,050.48
S/265.32
List Price:  S/379.05
You save:  S/113.72
K281.71
List Price:  K402.47
You save:  K120.75
SAR262.77
List Price:  SAR375.40
You save:  SAR112.63
ZK1,934.92
List Price:  ZK2,764.29
You save:  ZK829.37
L334.42
List Price:  L477.77
You save:  L143.34
Kč1,702.59
List Price:  Kč2,432.37
You save:  Kč729.78
Ft27,646.05
List Price:  Ft39,496.05
You save:  Ft11,850
SEK kr772.42
List Price:  SEK kr1,103.50
You save:  SEK kr331.08
ARS$70,259.44
List Price:  ARS$100,374.93
You save:  ARS$30,115.49
Bs483.50
List Price:  Bs690.75
You save:  Bs207.24
COP$307,238.59
List Price:  COP$438,931.09
You save:  COP$131,692.49
₡35,641.51
List Price:  ₡50,918.63
You save:  ₡15,277.11
L1,768.23
List Price:  L2,526.16
You save:  L757.92
₲546,248.87
List Price:  ₲780,388.98
You save:  ₲234,140.10
$U2,983.14
List Price:  $U4,261.82
You save:  $U1,278.67
zł291.40
List Price:  zł416.31
You save:  zł124.90
Already have an account? Log In

Transcript

Now in this video we will be predicting the probability for y equal to even for every customer or for every individual where each observation denotes one individual who has applied for loan and this criteria probability will be created in a separate data set. So let's do that. Let's predict the probability for equal treatment. So we will be using the procedure proc logistic data. I hope you'll remember that before we run this procedure proc registry data we have to execute our live name statement to bring our data set in SAS environment. So I have shown you on how to execute a lipstick in our last video.

So the live name statement is already executed over here to bring the data set in the SAS environment. So my library name is minus one doc logistic underscore rake underscore German underscore back the S is a keyword to create the model for y equal to one that is equal to even now model responses may dependent variable i will mentioned the significant independent variables or I will specify the significant independent variables that are focus on significant significant independent variables. So let's specify them we have to specify the weight is given in the data set So these are the significant independent variables that is check account, duration, history save account, new car education guaranteed Neil single other installed, installed rate, amount used car, foreign and rent. These are the significant independent variables Now I'm using the statement output Output out out is the key word that he will be using to create the duplicate data set.

My duplicate data set name is resolved which will be created in Zed work because I have not specified in library name p equal to predict it which is used to predict the probability for Viper to event then run so now let's run this code. Before I run the code Let me explain you all the code. So we have used the procedure proc logistic details equal to library name dot data set name. d s is a key word to build a model for rivals to one that is very close to even modern response. As our dependent variable equal to these are the list of significant independent variables which we have obtained in our last result viewers, that is during stepwise selection these are the significant independent variables. That is check account duration history save account new car education character a single other install install rate amount used car foreign rent, we are creating a duplicate data set that is resolved where the predicted probabilities for y equal to one will be displayed.

So the predicted probabilities that is we're predicting the probability for y equal to one that parity priority will be displayed in the data set called resolve which is created in network as I did not specify any library name it will create interwork and then run so now let's run this code. To see here we got the table for percentage concordance percentage discordant percentage tight higher is better percentage amount of concordance better is our model that is less is the risk classification This is odds ratio estimates table this is my analysis of maximum likelihood estimates table that is maximum likelihood estimation is used to estimate the parameters for logistic regression. Okay we are building a model for Y equals to one and as we know that the number of levels for a response variable will be two because response variable is binary in nature. taking two values either zero or one zero denotes non event and one denotes even now let's see the data set that we have created that is resolved.

It is created inside work So, let's open the library work. It's open that he does it result. So, the result is a copy of the original data set that is logistic German bank. So then add it as it got popped in reserve. In addition to that, we have also got another variable that is the estimated growth This is the bank depravity. For Bibles to one that is a greater priority for each customer provide most to one arrivals treatment is distinct.

So, for each customer customer what is the estimated probability that the loan can be given to the customer or the customer will not be alone default is displayed over here this is estimated probability This is listed for all the thousand observations, the thousand observations or the thousand customers who had applied for the loan now, we will be learning this much in this video. Before we move to the next video let me recap the concepts that we have done in the last videos we are using an interest magnetics dataset where we had built a model for Y equals to one and y equals to one denotes that the customer will not be alone default default that that is loan can be given to that customer we had done supply selection for our model. To select the significant independent variables there are total independent variables out of which 14 independent variables are significant ones.

The significant variables are chosen using residual chi square test variation. Notice the model does not require any more variables and each one is a model requires more variables. This is the null hypothesis and alternative hypothesis for a suitable chi square test. We had also we also did Harshman MC goodness of fit test to check the goodness of fit for the model where we concluded that the model is a good fit because our P value is greater than our level of significance that is 0.05. Because the tables are all issue estimates we got the table for analysis of maximum likelihood estimates we also got the table of percentage of components discordance or type s were higher is the percentage of concordance better is our model that is less than his classification. We also generated a classification table for every level of probability from zero to one with a gap of 0.01.

And we got the different measures of classification table that is, correctly classified events correctly classified non events in Korea classified events if the president non events total amount of percentage correctly classified then sensitivity specificity false positive false negative for every level of probability from zero to one, we had created a data set called result where we had predicted the probability for Y equals to one for each customer. That is weird. predict the gravity for each customer, we are predicting the probability for Y equals to one for each customer means that what is the probability that the each customer can be given the loan or the customer will not be a loan default what is the probability that we had predicted and it was, it was displayed in the data set result to the plaintiff gravity for y equal to one is displayed in the data set result which is created in network now in our upcoming videos, we will be setting up a cutoff probability level to convert this estimated priority to a variable called status which is going to take binary value that is zero or one by setting up the cutoff gravity level we will be converting them estimated probability variable to a status variable which will take values zero or one and then we will be doing the confusion matrix between the observed response variable and the predicted response variable which will be a status variable and then we will be calculating the different measures of the confusion matrix manually For now, let's end this video over here.

Thank you. Good. Well, we'll see y'all for the next video.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.