How to resolve for % in the macro statement?

[Sameer440909]

%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

[PeterClemmensen]

Wrap the % in the %Nrstr Macro Quoting Function

[Sameer440909]

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.%)"

[Kurt_Bremser · Accepted solution]

Separate the parts, so no macro resolution is tried:

%macro car_type(ty=);
proc sql;
create table tmp as
select *
from sashelp.cars
where upcase(type) like "%"!!"&ty."!!"%"
;
quit;
%mend;

%car_type(ty=SUV)

[Sameer440909]

Thank you so much @Kurt_Bremser. The solution worked fine. Thanks again

[Ksharp]

Using CONTAINS operator instead.

where upcase(type_new) contains "&ty."