topic Re: How to resolve for % in the macro statement? in SAS Programming

How to resolve for % in the macro statement?

Sameer440909 — Wed, 24 Nov 2021 09:49:20 GMT

%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

Re: How to resolve for % in the macro statement?

PeterClemmensen — Wed, 24 Nov 2021 09:58:46 GMT

Wrap the % in the %Nrstr Macro Quoting Function

Re: How to resolve for % in the macro statement?

Sameer440909 — Wed, 24 Nov 2021 10:24:07 GMT

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

Re: How to resolve for % in the macro statement?

Kurt_Bremser — Wed, 24 Nov 2021 10:27:04 GMT

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)

Re: How to resolve for % in the macro statement?

Sameer440909 — Wed, 24 Nov 2021 10:34:01 GMT

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

Re: How to resolve for % in the macro statement?

Ksharp — Wed, 24 Nov 2021 12:36:30 GMT

Using CONTAINS operator instead.

where upcase(type_new) contains "&ty."