I am trying to find  "Paclitaxel" in the string, however I could not find it using index , and , findw , function even I only keep aplphbet and ","  .  However, I can find "carboplatin"  .    Any solution ?  Thank you very much!     test = compress(lowcase(regimen),'abcdefghijklmnopqrstuvwxyz,','k') ; if index(test, 'paclitaxel') = 1 then pre_TAXANE = 1 ;   regimen Afatinib,Carboplatin,Paclitaxel 1 . . Afatinib,Carboplatin,Paclitaxel Protein-Bound 1 . . ... View more

Hello,    May you help with what is wrong about following macro?  Thank you.   -Ivy    %macro t ; %let group = 'SORAFENIB_1stline' ; %if &group. in ( 'SORAFENIB_1stline' , 'commercial', 'Cirrhosis', 'meta') %then %do; proc sql; select count(distinct enrolid) into: cntt from ads.cohort ; quit; %end; %mend; %t;   15 %macro t ; 16 %let group = 'SORAFENIB_1stline' ; 17 18 %if &group. in ( 'SORAFENIB_1stline' , 'commercial', 'Cirrhosis', 'meta') %then %do; 19 proc sql; 20 select count(distinct enrolid) into: cntt 21 from ads.cohort ; 22 quit; 23 %end; 24 %mend; 25 26 %t; MLOGIC(T): Beginning execution. MLOGIC(T): %LET (variable name is GROUP) ERROR: Required operator not found in expression: &group. in ( 'SORAFENIB_1stline' , 'commercial', 'Cirrhosis', 'meta') ERROR: The macro T will stop executing. MLOGIC(T): Ending execution. ... View more

Hello,   I am trying to use the following commend to output Survial curve in SAS EG, but it did not work. May you help ? Thank you.   ods pdf file="/Mango/reports/Figure1_survival.pdf"; ods graphics on ; proc lifetest data = ads  plots=survival(atrisk test); time follow_up_months*event(0) ; strata cohort / test = logrank ; run ;   Ivy  ... View more

Hello,    Is there any efficient way to pick up the characters ICD 9/ICD 10 codes, rang from 140-161 , 200-2093 , C45-C76, from diangosis code ?   Thank you, Ivy  ... View more

Hello,    I would like to delete the ID with more than 2 coutinous 0 value of RX. I am wondering what is efficient way to do it.   Thank you very much.   ID    RX      1        1 1       1 1       0 1        1 1       0 1        1 2        0 2       0 2        1 ... View more

Hello,    I just swiched from PC SAS to SAS EG 7.1. I tried to run code step by step, however EG run the whole program instead of  highlighted part of program.   I am wondering the solution of this.   Thank you very much,  Ivy  ... View more