Date:         Mon, 9 Oct 2006 08:05:45 -0700
Reply-To:     Arjen <a.benedictus@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arjen <a.benedictus@GMAIL.COM>
Organization: http://groups.google.com
Subject:      issue with resolving macros
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hello SAS-L,

I have the following issue with respect to macro lingo:

%Macro Lingo (l1);
proc sql noprint; select &l1 into :&l1 separated by ' '
from Lingo; quit;
%MEND Lingo;

When I try to resolve the macro using
%Lingo(French);
NOTE: PROCEDURE SQL used:
      real time           0.00 seconds
      cpu time            0.00 seconds

And subsequently
%PUT &French;
Then I get this:
WARNING: Apparent symbolic reference FRENCH not resolved.
&French

BUT, when I (step 1) put the word French hard-coded in the sql-code,
then (step 2) %put the list, I get to see the list. And when I try to
run the macro again (step 3), it does work and &French is resolved.

The same applies for German and Italian. I have to run the sql with
these words hard-coded in it, and only then I can play around with
putting those words within the macro-brackets.

What am I doing wrong/ what is happening?

Arjen