About MikeTurner

MikeTurner · ‎08-20-2013

Hi Guys, I want to rank my my data within groups, so I used lag function in my codes. But it seems this function does not work. I'm wondering why lag1(mylabel) is missing when _n_=2. Anyone could help me out? Thanks. Mike data cake; input Name $ 1-10 type 12-13 Taste 15-16; datalines; Davis 1 84 Orlando 1 80 Ramey 1 72 Roe 2 75 Sanders 2 79 Simms 2 77 Strickland 2 79 ;run; proc sort data=cake; by type taste;run; data a; set cake; by type taste; if type=lag1(type) then mylabel=1+lag1(mylabel); else mylabel=1; if _n_=1 then mylabel=1; run;

MikeTurner · ‎08-12-2013

Dear All, I have one text-mining project on short text. I'm wondering if there is one macro or function to parse short text? Thanks Mike

MikeTurner · ‎08-05-2013

Thanks a lot for all kind reply. Greatly appreciated. Mike

MikeTurner · ‎08-05-2013

Thanks. But it will not work if if you have hundreds of words in one string................

MikeTurner · ‎08-05-2013

Dear All, I'm doing one text mining project.One observation is one string and one indicator. I need to count the frequency of each word in the string and I will get one new dataset with many columns. The name of one column is the word and the content is the the frequency of the word in one observation. The indicator remains unchanged. How to implent this using sas if I have hundreds of words in one string? Thanks. Have string indicator a b c 1 a c d d a 1 a b c 2 f g g h 2 e f e a m 1 Want a b c e d f g h m indicator 1 1 1 0 0 0 0 0 0 1 2 0 1 0 2 0 0 0 0 1 1 1 1 0 0 0 0 0 0 2 0 0 0 0 0 1 2 1 0 2 1 0 0 2 0 1 0 0 1 1 Tomi

MikeTurner · ‎03-01-2013

Great! Thanks.

MikeTurner · ‎02-25-2013

when the success rate is small for logistic regression? Thanks.

MikeTurner · ‎10-16-2012

Got it. Thanks

MikeTurner · ‎10-16-2012

I defined one macro variable VAR, then I wrote the codes as below; %if %UPCASE(&VAR) NOT IN ("ABC", "XYZ") %THEN %DO; BLABLABLA; %END; It seems incorrect, is there one statement in MACRO equal to "not in" or "in" statement? Thanks in advance.

MikeTurner · ‎08-30-2012

I opened a new sas session. It seemed that the codes sometimes worked fine and sometimes not. Please have a look at the log. Thank all. 16 %macro indd(in); 17 %if %upcase(&in)=YES %THEN %do; 18 19 %end; 20 %else %do; 21 noint 22 %end; 23 %mend; 15 %put i'm running %indd(no); --------------------- 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 24 option mprint symbolgen mlogic; 25 %put i'm running %indd(no); MLOGIC(INDD): Beginning execution. MLOGIC(INDD): Parameter IN has value no SYMBOLGEN: Macro variable IN resolves to no MLOGIC(INDD): %IF condition %upcase(&in)=YES is FALSE MLOGIC(INDD): Ending execution. i'm running %indd(no);%macro indd(in);%if %upcase(&in)=YES %THEN %do;%end;%else %do;noint%end;%mend;option mprint symbolgen mlogic;%put i'm running noint 26 %put i'm running %indd(no);

MikeTurner · ‎08-30-2012

Thank you, Ksharp. I tried your codes and still didn't work. I suspected something wrong with my computer's setting. I tried your codes and my codes on my colleague's computer and all worked fine. Thanks.

MikeTurner · ‎08-30-2012

I tried the codes on my colleague's computer and it worked fine. But not on my computer. It's so weird.

MikeTurner · ‎08-30-2012

I wrote the macro indd and I'm wondering why the macro can't be resolved when I call the macro by: %put i'm running %indd(no). Is there something wrong with the macro? Thanks in advance. %macro indd(in); %if %upcase(&in)=YES %THEN %do; %end; %else %do; noint %end; %mend; %put i'm running %indd(no);

MikeTurner · ‎08-21-2012

Thanks for your reply. I downloaded the macro from sas.com. It seems that the macro needs to connect the sas server.................. http://support.sas.com/kb/25/010.html

MikeTurner · ‎08-21-2012

I met with one error as below when i was running %polycho. Anyone knows what is happening? How to fix it? Thanks in advance.... 17 %polychor(var=_NUMERIC_) ERROR: Connection refused. POLYCHOR: Unable to check for newer version

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

What's wrong with codes?

Is there one macro or function to parse short text?

Re: How to count the frequency like this?

Re: How to count the frequency like this?

How to count the frequency like this?

Re: How to implement oversampling in Enterprise Miner?

How to implement oversampling in Enterprise Miner?

Re: "not in" Statement does not work in Macro?

"not in" Statement does not work in Macro?

Re: Is the macro correct?

Re: How to use Macro in referencing Excel worksheet names?

Re: How to get the number of variables in one list?

Re: Concatenate multiple rows into a single value

Re: Concatenate multiple rows into a single value

Re: Count the keywords of the string

What's wrong with codes?

Is there one macro or function to parse short text?

Re: How to count the frequency like this?

Re: How to count the frequency like this?

How to count the frequency like this?

Re: How to implement oversampling in Enterprise Miner?

How to implement oversampling in Enterprise Miner?

Re: "not in" Statement does not work in Macro?

"not in" Statement does not work in Macro?

Re: Is the macro correct?

Re: Is the macro correct?

Re: Is the macro correct?

Is the macro correct?

Re: How to fix the error "ERROR: Connection refused. "?

How to fix the error "ERROR: Connection refused. "?