Hi All, I am trying to use following piece of code to conditionally execute select clause based on dataset. proc sql ; create table xyz as %if %sysfunc(prxmatch("m/abc/oi",&stud)) > 0 %then %do ; select a.*, cohort, regimen, dxloc as tumor %end; %else %if %sysfunc(prxmatch("m/yuh/oi",&stud)) > 0 %then %do; select a.*, cohort, regimen, dxloc_std as tumor %end; I am getting this error ERROR: Required operator not found in expression: prxmatch("m/abc/oi",&stud) > 0 what am I doing wrong here ?
... View more