Hello Everyone,
Can I write a code make multiple 'OR' statements into one row? please see the code, the new method does not work.
proc sql;
create table old_method as
select * from sashelp.baseball
where
upcase(name) like '%BI%'
or
upcase(name) like '%AI%'
or
upcase(name) like '%AE%'
/* we have more or statements*/
;
quit;
*--the new method does not work;
proc sql;
create table new_method as
select * from sashelp.baseball
where
upcase(name) like in('%BI%','%AI%','%AE%');
quit;
Thanks!
... View more