Date:         Wed, 6 Mar 1996 10:30:29 -0500
Reply-To:     Roger Deangelis <deangel@HORIZSYS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Roger Deangelis <deangel@HORIZSYS.COM>
Subject:      Macro quoting problem

Macro quoting problem (this is a real problem)
 
 Consider:
 
  data x;
 
     string="SKIP";
     output;
     string="HITS";
     output;
 
  run;
 
 
  proc sql;
 
     select   *
     from     x
     where string like '%IT%';
 
quit;
run;
 
 
The challenge is to create the '%IT%' as clear text to the
 sql where clause:
 
 
User must start with
 
   %let arg=IT;
 
and up with clear text '%IT%' in where clause:
 
 
I will post my solution.
 
My solutions are a bit convoluted and I do not want to
show my ignorance at this time.