Create global macro variables such as
%let _INPUT1=MYDS;
and test the SQL or DATA steps outside of your macro. You should be able to pinpoint the troublesome step by checking the log. If every step works as intended, then the problem is with macro logic.
... View more
