topic Re: sas macro and wilcard in SAS Programming

sas macro and wilcard

JohnnySas — Wed, 03 Oct 2018 04:36:55 GMT

%let catg0 = COMPANY ABC;

proc sql;

create table XYU

as select

a.* from

tableb a

where companyname like %nrstr(%')%str(%%)&&catg0%nrstr(%%)%str(%'));

run;

How do I make it resolve to :

where companyname like '%COMPANY ABC%'

Re: sas macro and wilcard

ChrisNZ — Wed, 03 Oct 2018 05:44:08 GMT

There may be better ways but this works:

where name like %unquote(%nrbquote('%str(%%)%superq(catg0)%'));

Re: sas macro and wilcard

Kurt_Bremser — Wed, 03 Oct 2018 06:50:56 GMT

Couldn't that be solved by

data xyu;
set tableb;
where index(companyname,"&catg0.");
run;

Re: sas macro and wilcard

RW9 — Wed, 03 Oct 2018 07:24:41 GMT

Or use a function:

where index(companyname,"&catg0.");

Re: sas macro and wilcard

JohnnySas — Sat, 06 Oct 2018 21:06:19 GMT

Thank YOu. This worked for me

Re: sas macro and wilcard

Tom — Sun, 07 Oct 2018 18:24:07 GMT

It is a pain trying to do that in macro language, but since you are already generating some SAS code why not generate some SAS code to add the quotes and percent signs?

data _null_;
  call symputx('catg0_like',quote('%'||symget('catg0')||'%',"'"));
run;

proc sql noprint feedback;
create table XYU as 
  select a.* 
  from tableb a
  where companyname like &catg0_like
;
quit;