07-30-2020
mmagnuson
Quartz | Level 8
Member since
05-03-2017
- 62 Posts
- 2 Likes Given
- 3 Solutions
- 2 Likes Received
-
Latest posts by mmagnuson
Subject Views Posted 885 07-30-2020 03:06 PM 1304 07-09-2020 08:06 PM 1386 07-09-2020 02:16 PM 899 06-03-2020 01:45 PM 928 06-03-2020 12:53 PM 740 05-04-2020 11:16 AM 2407 09-28-2019 06:07 PM 2487 09-27-2019 10:00 AM 1564 07-31-2019 11:20 AM 1577 07-31-2019 08:31 AM -
Activity Feed for mmagnuson
- Posted Trying to delay SAS Schedule on SAS Enterprise Guide. 07-30-2020 03:06 PM
- Liked Re: Data exported is not the same as data imported for TomKari. 07-09-2020 08:07 PM
- Posted Re: Data exported is not the same as data imported on SAS Enterprise Guide. 07-09-2020 08:06 PM
- Posted Data exported is not the same as data imported on SAS Enterprise Guide. 07-09-2020 02:16 PM
- Posted Re: Join with AND function on SAS Enterprise Guide. 06-03-2020 01:45 PM
- Posted Join with AND function on SAS Enterprise Guide. 06-03-2020 12:53 PM
- Posted SAS GUI to Code on SAS Enterprise Guide. 05-04-2020 11:16 AM
- Posted Re: Exporting numeric variable to Excel Table but shows as character on SAS Enterprise Guide. 09-28-2019 06:07 PM
- Posted Exporting numeric variable to Excel Table but shows as character on SAS Enterprise Guide. 09-27-2019 10:00 AM
- Posted Re: Creating new columns where data doesn't match on SAS Enterprise Guide. 07-31-2019 11:20 AM
- Posted Re: Creating new columns where data doesn't match on SAS Enterprise Guide. 07-31-2019 08:31 AM
- Posted Creating new columns where data doesn't match on SAS Enterprise Guide. 07-30-2019 12:58 PM
- Tagged Creating new columns where data doesn't match on SAS Enterprise Guide. 07-30-2019 12:58 PM
- Tagged Creating new columns where data doesn't match on SAS Enterprise Guide. 07-30-2019 12:58 PM
- Got a Like for Re: Case Statement Multiple Ends or One?. 03-26-2019 10:11 AM
- Got a Like for Re: Case Statement Multiple Ends or One?. 03-26-2019 10:11 AM
- Posted Joining Data without blank line where data doesn't match on SAS Enterprise Guide. 12-17-2018 09:50 AM
- Posted Ordered Lists Multiple Selections on SAS Enterprise Guide. 02-14-2018 02:41 PM
- Posted Re: Output Automatically Opens on SAS Enterprise Guide. 02-12-2018 01:54 PM
- Posted Re: Output Automatically Opens on SAS Enterprise Guide. 02-12-2018 01:48 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 -
My Liked Posts
Subject Likes Posted 1 10-30-2017 03:48 PM 1 10-30-2017 10:39 AM
05-25-2017
01:47 PM
Luckily all info in the varialbes is accounted for. So the initial research question was what factors contribute to donationg more or not. First i looked at each independent variable compared with the dependent varaible and recorded the odds ratio. Then I loaded all of the independet variables in the model and the odds ratios fluctuated from when they were looked at individually vs as a group (attached). The difference with the odds ratio must be due to all the other variables being in the equation. But I guess what I'm hung up on is which odds ratio is "right" since there are odds ratios of the logistic regression analysis and odds ratios of comparing individual independent varialbes and the dependent variable.'' Would it be fair to say that the model would be more appropriate because it takes into account 13 other variables which is more "real life" since when making conclusions one should look at many variables? Looking at just one variable is limiting?
... View more
05-25-2017
01:10 PM
Using only one variable i obtained a c statistic of .5. When I included the other 14 variables in my logistic regression model the c statistic increased to .74 which seems to be "good" in terms of the model. The only issue is that when I did this some odds ratios fluctuated but I'm guessing that has to do with taking into account the other variables in the model? Example: In the picutre. it shows odds ratio of 2.83 but when added with all the other variables it decreases to 1.12. Should both numbers be reported? One number being (2.83 - only if you look at this on variable) and (1.12 when you look at all varaibles in the model)?
... View more
05-25-2017
12:38 PM
So if the C statistic shows that there is no linear relationship then I should still be able to report the odds ratio. The odds ratio doesn't need to worry about linearity at all correct? In that case, would it be better to not run a logistic regression model and just manually calculate th odds ratios for each varaiable?
... View more
05-25-2017
12:14 PM
I ran a logistic regression model with only one independent variable. The c statistic was .5 which means that the model is no better than random chance. When I looked at the cross tabulation between the dependent and independent variable and ran a chi-square i got an x2 value of 931 with my chi squared value 3.84. It showed to be significant. The odds ratio was 2.83. My question is that if it is significant then why does the model report .5 which seems like it would be only on chance. Is the model not appropriate for that specific independent variable since it shows only .5 for the c-statistic or is the c-statistic not that important? There are 61000 rows of data. I have 10 variables that I'm looking at but have run them all in the regression analysis and have also looked at them independently to see if there are effects when others are added. Which there is. Odds ratios change minorly when other varaialbes are added. All independent variables are binary.
... View more
05-10-2017
11:11 AM
Ah this makes a lot of sense!! I took out two continuous variables and was left with only 18 binary variables and the output gave me 3.5 odds ratio which makes more sense. If i want to include continuous varibales in ivs' should I run a separate logistic regression model with only continuous iv?
... View more
05-10-2017
09:53 AM
That makes sense since the c statistic was .50 which seems like a flip of a coin. I added more variables and it showed an odds ratio of .426 which would mean that if someone was IN the BEC then they have .42 times less liklihood of being a donor. Does this coincide with the cross tab referece though?
... View more
05-10-2017
09:36 AM
Wouldn't proc logistic tell me the odds if my dependent variable is binary = Donor (0/1) and then i have a dummy variable?
... View more
05-10-2017
08:48 AM
Attached is the cross tab of my dependent variable DONOR and independent variable BEC. If someone is in the BEC then they seem to donate 18.67 times more than if someone is not in the BEC. I ran a logistic regression: proc logistic data=work.work; class BEC (ref='0'); model donor(event='1') = BEC; run; and came up with 18.67 odds ratio and a C statistic of .50 Then, I included 19 more variables and ran the logistic regression again. This time, the odds ratio was .426 and the c statistic was .77. Is something wrong with my model? It doesn't seem like .426 makes sense if you look at the cross tab. Thank you for any help!
... View more
05-05-2017
11:45 AM
Sorry that I wasn't clear but luckily you were! Thank you!
... View more
05-05-2017
10:51 AM
No. I am trying to figure out what facotors would contribute to someone making a donation or not. My dependent variable is donor and my independent variable is Prereffred Professional Suffix and AlsoParent to figure out if those who have a professional suffix or are also parents will have greater odds of being a donor. Does that make sense?
... View more
05-05-2017
10:15 AM
It seems like GLM is for more linear models and is different than a logistic model. If I merely reversed my dataset so that Y was no and N was yes would that solve the problem?
... View more
05-05-2017
09:53 AM
Forgot to attach it. Here is the output. Thanks. My dependent variable is Donor (1 for yes and 0 for no) if I run this code it looks for an event of 1 which would be a donor but the iv's show up as No. It seems like my output would be "These are the log odds of a person not having this iv if they are a donor which is awkward to explain to NOT look for the iv's of the population. It'd make more sense to describe it saying "these are the log odds of a person HAVING this iv and donating". I'm just not sure if there's a way with the code that I could have the Y value of the iv come up in the output instead of the N value. Hope I explained it well.
... View more
05-05-2017
09:22 AM
I used the CLASS statement in a simple logistic regression model with only two independent variables. These variables were Preferred_Prof_Suffix and AlsoParent . The values were Y o rN . When the model was run the output showed Preferred_Prof_Suffix N and AlsoAParent N. Does this mean the output shows negative responses towards the dependent varaible? Should I interpret the output in terms of the reciprocal or is there a way for the independent variables to show up as Y in the output? output used: proc logistic data=work.work; class Preferred_Prof_Suffix AlsoParent; model donor(event='1') = Preferred_Prof_Suffix AlsoParent; run;
... View more
05-04-2017
01:15 PM
From the info above my code is the following: Where would the var ref=1 go? I tired before the i.v.s and after the i.v.s in the first line but it errored. (also I Bolded the variables for clarification purposes) PROC LOGISTIC DATA=WORK.SORTTempTableSorted PLOTS(ONLY)=ALL ; CLASS BEC (PARAM=REF) "Marital Status"n (PARAM=REF) Gender (PARAM=REF); MODEL Donor (Event = '1')=BEC "Marital Status"n Gender / SELECTION=NONE AGGREGATE SCALE=NONE RSQUARE LINK=LOGIT CLPARM=WALD CLODDS=WALD ALPHA=0.05 ; RUN;
... View more
05-04-2017
12:44 PM
I went ahead and put it under CLASS with Reference coding style. In the output it showed the MLEs for only the 0 value. To interpret this would it be the 0 value has a negative estimate which would mean that the 1 value would then be a positive estimate? Just making sure I understand this completely.
... View more
- « Previous
- Next »