About manonlyn

manonlyn · ‎12-10-2019

I've got it to validate today! Thanks for all your help with this it's really appreciated. If I have similar questions in the future I'll be sure to post them on the stat board.

manonlyn · ‎12-10-2019

I don't think I have anything under that option. I just put CLASS then list the class variables followed by (REF = 'NULL') Thanks.

manonlyn · ‎12-09-2019

1. They would need to have a suitable Value of Information and make logical sense for the trend. 2. Predictive. 3. Approx 6000 observations 4.The categorical variables have different levels, I am only modelling categorical variables. 5. Not sure what this question means. 6. Yes, I analyzed over 200 variables (categorical) to make sure the levels made logical sense and combined levels where needed. Thanks for your interest in helping me with this.

manonlyn · ‎12-06-2019

Is this the method I should use if I'm modelling categorical variables too? As I will have maybe 4 different "bands" coming in for the class variables, so I null the band that has P>0.05 or do I null the whole variables if one band has that value? Thanks for your help with this, it's much appreciated.

manonlyn · ‎12-06-2019

Thanks for this! I'm building the model using Proc Logistic, then in the output table "Summary of Stepwise Selection" there weren't any variables that had a Pr>Chi-Square value >0.05, is this the P Value? I have dropped a couple of the variables which has left me with 22 variables and the validation is slightly better but not fully validated. I've not used proc hpgenselect before so I'll read up on that and how to use it to help my model build.

manonlyn · ‎12-06-2019

I've got a statistical model with 27 Variables coming in. It was built on a Train dataset and tested on a Test dataset, I've tested it through a KS test and PSI. It fails the KS Test which I think shows that it's overfitted. I'm just not sure what I should do next? Should I start taking some of the variables out of the model? If so, how do I decide which ones? Do I let other variables come in instead of the ones I'm taking out?

manonlyn · ‎10-14-2019

Analysis of Maximum Likelihood Estimates Parameter DF Estimate Standard Error Wald Chi-Square Pr > ChiSq Intercept 1 -3290.3 703.3 21.8867 <.0001 Var1 1 -0.00163 0.000226 52.2701 <.0001 Var2 1 -0.00526 0.000466 127.441 <.0001 Var3 1 0.000958 0.00027 12.608 0.0004 Var4 1 -0.0001 0.000038 7.1978 0.0073 Var5 1 -0.3936 0.0369 113.85 <.0001 Var6 1 0.000088 0.000016 31.0853 <.0001 Var7 1 -0.002 0.000298 45.2192 <.0001 Var8 1 0.0126 0.00317 15.871 <.0001 Var9 1 -0.00046 0.000152 9.2876 0.0023 Var10 1 -0.00307 0.000654 22.0835 <.0001 Var11 Y 1 -0.4135 0.0961 18.5191 <.0001 Var12 1 3.11E-06 7.86E-07 15.6228 <.0001 Var13 1 0.000163 0.000035 21.8936 <.0001 Var14 HI 1 -0.276 0.0988 7.8036 0.0052 Var14 LO 1 0.0772 0.0714 1.1689 0.2796 Var14 VH 1 -0.4861 0.0891 29.767 <.0001 Var14 VL 1 0.5337 0.1432 13.8923 0.0002 Var15 1 0.0193 0.00414 21.7022 <.0001 Var16 1 0.00149 0.000291 26.3576 <.0001 Var17 1 -0.2849 0.0557 26.1488 <.0001 Var18 1 0.000088 0.000018 23.3451 <.0001 Var19 1 0.00291 0.000628 21.5079 <.0001

manonlyn · ‎10-14-2019

At the moment I'm building quick models to analyse if it's worth segmenting. I'm not sure how I would standardize variables? What does this usually include? Thank you.

manonlyn · ‎10-11-2019

The P value for the variable with the estimate of 3.11E-6 is <.0001

manonlyn · ‎10-10-2019

Thank you I'll start with those, this has been really helpful thanks again.

manonlyn · ‎10-10-2019

Sorry it's just in the past my Intercept value has been more similar to the parameter estimates, this is the first time they've been extremely different and I was wondering if I needed to fix something. Are the outliers outputted as part of Proc Logistic? It might be worth noting that I'm just building quick scorecard for Segmentation Analysis before I start the actual scorecard builds.

manonlyn · ‎10-10-2019

I am running Proc Logistic in SAS with Stepwise selection. My results show the Intercept with an estimate of -3290.3 while the other parameters vary with values such as 0.5337, 3.11E-6, 0.000088 etc. This is the first time I've had such differing values, would anyone be able to explain in layman's terms what this means? And possibly what fixes I could do? Or maybe more things to look into? Unfortunately, I am the only analyst within the business so I have no support from others who work from me as they don't understand the methodology. Thanks in advance!

manonlyn · ‎07-11-2019

I've posted the actual cell that's caused the issue in the first reply. I think I might have to preprocess the CSV. Thanks for your time looking into this.

manonlyn · ‎07-11-2019

I'm going to open up in Excel and get rid of the line breaks like that. Thanks for all your help!

manonlyn · ‎07-11-2019

It's separating each sentence into a new column , but the amount of words from the sentence depends on the column length. I think this happens when ALT+ENTER has been used within Excel to write in a cell. I want these sentences to stay within one column if possible? I have the DSD within the infile statement and I still have the same issue.

Online Status	Offline
Date Last Visited	‎12-16-2019 10:22 AM

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Validation of Statistical Model Failed

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Re: Validation of Statistical Model Failed

Validation of Statistical Model Failed

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Proc Logistic Output

Re: Proc Logistic Output

Proc Logistic Output

Re: Reading in CSV using INFILE and INPUT

Re: Reading in CSV using INFILE and INPUT

Re: Reading in CSV using INFILE and INPUT