I have been pulling my hair out with this. I want to create a macro that submits some SQL code. The SQL code contains a WHERE clause using the LIKE operator. I need to include a macro variable in the LIKE string. Here is what it looks like.
%Macro MyMac(name);
Proc SQL;
Select *
From somefile
WHERE somefield LIKE "%&name%";
%Mend;
%MyMac(jeff);
The resulting SQL code should look like
Proc SQL
Select *
From somefile
WHERE somefield LIKE "%jeff%";
Those two percent signs are killing me. Can anyone come up with a series of macro functions that would result in the string Im looking for? Your help is appreciated.
Jeff
... View more
