Thanks for the replying. I tried but empty data is generated. Would be very helpful if you can show the exact syntax. This is how I have written based on your suggestion, where upcase(type_new) like "%nrstr(% &ty.%)"
... View more
%macro car_type(ty=); proc sql; create table tmp as select * from cars where upcase(type_new) like "%&ty.%" ;quit; %mend; The part highlighted in red triggers an error. How to get around this? Please help. Thanks
... View more
