Hello, I'm trying to invoke a macro from my code but I keep getting this error: WARNING:Apparent invocation of macro TEST not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. This is the code that I'm calling the macro from: Options
Mautosource
Sasautos = ('unix link where the test.sas file is located')
source2
nocenter mlogic symbolgen
;
%test(table.acct,acct); when I copy paste the entire macro in the code, it runs fine. which confirms there is nothing wrong with the macro. Below is the macro definition in the file test.sas: %macro test(table,var);
proc sql noprint;
CONNECT TO teradata (user= "%sysget(user)" password = "&pass" tdpid="rchtera" mode=teradata);
create table abc as select * from connection to teradata
( select top 2 &var. from &table.);
disconnect from teradata;
quit;
%mend; I even tried using %include, but that hasn't helped either. In any case I would prefer invoking without using %include. Appreciate any help!
... View more