@karachi007 wrote:
Tom, No luck
this is my code:
%macro test(DSN):
proc sql;
create connection to ORACLE ,,,,,,,
create table employee_&DSN. as
select * from .&DSN. a
left join employee e
on a.id = e.id;
run;
%mend test;
%test(FILE1,FILE2)
quit;
getting errors:
more positional parameters found than defined
please advise and let me know the issue. Thank
The ERROR message is very clear and obvious: you defined the macro with only ONE parameter, and then tried to call it with TWO parameters. This is not possible.
... View more
