Hello all, I am having trouble figuring out how to use macro variables in proc sql. So I have the following: %let fullName = John Smith;
%macro JohnSmith;
title "Completed by &fullName on &sysday, &sysdate, &systime";
run;
%mend; I am trying to use it in the context of proc sql. Here is an example. /*Counting rows*/
proc sql;
select count(*) as NumOfRows
from Tmp1.myData;
quit; My guess would to write it like this, but I get no output. /*Counting rows*/
proc sql;
%JohnSmith
select count(*) as NumOfRows
from Tmp1.myData;
quit; Which part of my code is incorrect?
... View more
