Date:         Thu, 15 May 2008 14:44:31 -0700
Reply-To:     "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV>
Subject:      Re: Need to have % chars in a macro var--can I get rid of this
In-Reply-To:  <445d9dbe0805151420w657abdb5k109f455a3bfc9596@mail.gmail.com>
Content-Type: text/plain; charset=iso-8859-1

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of Yu Zhang
> Sent: Thursday, May 15, 2008 2:21 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Need to have % chars in a macro var--can I get
> rid of this
>
> it needs an "unquote" here,
>
> where result_code in ("%unquote(%superq(vdw_tests))");
>
> Yu
> On Thu, May 15, 2008 at 3:42 PM, toby dunn
> <tobydunn@hotmail.com> wrote:
>
> > where result_code in ("%SuperQ(vdw_tests)")
> >
> >
> >
> >
> >
> >
> > Toby Dunn
> >
> > "Don't bail. The best gold is at the bottom of barrels of crap."
> > Randy Pausch
> >
> > "Be prepared. Luck is where preparation meets opportunity."
> > Randy Pausch
> >

I tried this:

data result_codes ;
  input  @1 result_code $char9.  @12 vdw_name $char10. ;
datalines ;
PSA*H PSA
%FPSA*H PFPSA
QCPSA*H PSA
;
run;

proc sql noprint feedback ;
  select result_code into :vdw_tests separated by '", "'
  from result_codes
;
quit;
data test;
  set result_codes;
  if result_code in("%SuperQ(vdw_tests)") then put "'%' ok";
run;

From my try of the above, with %superq only, result_code is not found IN() the list and with %unquote added according to Yu Zhang's advice, the warning about an unresolved macro returns.  Any other suggestions?

Dan

Daniel J. Nordlund
Washington State Department of Social and Health Services
Planning, Performance, and Accountability
Research and Data Analysis Division
Olympia, WA  98504-5204