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>
Subject: issue with resolving macros
Content-Type: text/plain; charset="iso-8859-1"
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;
When I try to resolve the macro using
NOTE: PROCEDURE SQL used:
real time 0.00 seconds
cpu time 0.00 seconds
Then I get this:
WARNING: Apparent symbolic reference FRENCH not resolved.
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?