About fannavivian

fannavivian · ‎05-31-2017

Good add up!

fannavivian · ‎05-31-2017

Awesome!!!!

fannavivian · ‎05-31-2017

Thanks. I'm not worry about the case you just mentioned, because the first left letter of address is always a number in my db. But I do have a question that what if there're other delimitors, such as "suite", "#", "STE", so what's your recommendation?

fannavivian · ‎05-31-2017

Thank you~~ This is similar to what I thought, but yours is more detailed. Just to share what I figured out a moment ago. address=substr(ADDRESS1, 1, index(ADDRESS1, 'Apt') - 1);

fannavivian · ‎05-31-2017

Hi Guys, Got a question about separating Apt information from address. The data looks like this: Address 5213 Elmcrofa Blvd Apt 10210 5648 Sunset Blvd Apt 52103 ... I was thinking about using scan function, but not sure if the delimiter can be a character and how. The desired output would be like this: Address Apt 5213 Elmcrofa Blvd Apt 10210 5648 Sunset Blvd Apt 52103 Thanks, Fan

fannavivian · ‎02-22-2017

Appreciate your answer. Please correct me if I am wrong. As for SAS's calculation, it takes all the variables in the parameter estimates report, just the all the predictor variables. And as in your answers, there's still difference. So I really would like to know what makes the difference. Thanks!

fannavivian · ‎02-21-2017

Hi, Can anyone tell me how SAS calculates probalibility using proc logistic score statement? Why my manual probability calculation is so different from SAS's? Does SAS take all variables into calculation or only significant ones? P=exp(F)/(1+exp(F)) = 1 / (1+exp(-F)) Analysis of Maximum Likelihood Estimates Parameter DF Estimate Standard Error Wald Chi-Square Pr > ChiSq Intercept 1 -0.9724 0.2331 17.4036 <.0001 classA 1 1 0.0150 0.0827 0.0328 0.8562 classA 2 1 -0.0694 0.0380 3.3468 0.0673 classA 3 1 -0.1681 0.0467 12.9276 0.0003 classA 4 1 0.1498 0.0706 4.5050 0.0338 classB 1 1 -0.1760 0.0547 10.3536 0.0013 classC 1 1 1.4962 0.0280 2863.0571 <.0001 classD 1 1 -0.5437 0.0445 149.1918 <.0001 classE 1 1 0.1358 0.1794 0.5727 0.4492 classE 2 1 0.1191 0.3248 0.1345 0.7138 classE 3 1 -0.3680 0.4482 0.6740 0.4117 Numeric1 1 -0.2314 0.0197 138.3852 <.0001 Numeric2 1 0.000259 0.000040 42.9420 <.0001 Numeric3 1 2.1190 0.1641 166.7216 <.0001 Thank you!!! Fan

fannavivian · ‎02-20-2017

Thanks for your reply! Can you give me an example when PROC GLMSELECT should be used rather than PROC LOGISTIC, or vice versa?

fannavivian · ‎02-20-2017

I am new to SAS/STAT, and I am wondering what is the difference between PROC LOGISTIC and PROC GLMSELECT? The SAS syntax are very similar: both of them can run logistic regression models, both of them can have specific selection method (FORWARD, BACKWARD, STEPWISE), and both of them can be used to score a new dataset. The only difference I observe now is that PROC GLMSELECT can only be used to score a continuous response variable, while PROC LOGISTIC can be used to score binary response variables (eg: specify the event=1). Am I right on this? Is there any other difference that I should keep an eye on?

fannavivian · ‎12-30-2016

question #1 - Yeah, your are absolutely right! I forgot that point.

fannavivian · ‎12-29-2016

Hi guys, I have a question about member enrolling and dropping. Suppose there are Jan, Feb, March, ... Dec 2016 member data, total 12 dataset. In each dataset, variables are the same (>100 variables). Would like to see who drops and who enrolls. My code is as following: %LET measure = var1; data enroll (keep=MEMBERID &measure flag) drop (keep=MEMBERID &measure flag); merge Jan2016Data (keep=MEMBER &measure IN=a) Feb2016Data (keep=MEMBER &measure IN=b); by member; if b then flag="enroll"; if a then flag="drop"; if &measure ^= ""; /*there are many missing value which need to be excluded basing on the requirement*/ if a ^= b; if flag="enroll" then output enroll; if flag="drop" then output drop; run; Issure: 1. how to make &measure in Feb2016Data not to overwrite Jan2016Data? 2. Why sas result is different than my manual result (compared in excel)? Is there anything wroing? (no error msg in log) Thanks!! Viv

fannavivian · ‎12-13-2016

Hi this is also my first post. Contributed to geodist function~~ How accurate is HAVERSINE formula (earth radius of 3949.99 miles used to produce distance in miles)? And how accurate is geodist to R result if running by R? I felt SAS calculated result is a little less accurate than R. (Hope someone can explain or correct...) Thanks!

Online Status	Offline
Date Last Visited	‎02-16-2021 08:16 AM

Re: Separate Apt information from Street information

Re: Separate Apt information from Street information

Re: Separate Apt information from Street information

Re: Separate Apt information from Street information

Separate Apt information from Street information

Re: Calculation about score function in Proc Logistic

Calculation about score function in Proc Logistic

Re: what is the difference between PROC LOGISTIC and PROC GLMSELECT?

what is the difference between PROC LOGISTIC and PROC GLMSELECT?

Re: Member enroll and drop with Merge statement

Re: Separate Apt information from Street information

Re: Separate Apt information from Street information

Re: Help with Do loop through a list of variables

Re: sums and counts by group

Re: Calculation about score function in Proc Logistic

what is the difference between PROC LOGISTIC and PROC GLMSELECT?

Re: Separate Apt information from Street information

Re: Separate Apt information from Street information

Re: Separate Apt information from Street information

Re: Separate Apt information from Street information

Separate Apt information from Street information

Re: Calculation about score function in Proc Logistic

Calculation about score function in Proc Logistic

Re: what is the difference between PROC LOGISTIC and PROC GLMSELECT?

what is the difference between PROC LOGISTIC and PROC GLMSELECT?

Re: Member enroll and drop with Merge statement

Member enroll and drop with Merge statement

Re: SAS GEODIST function