%macro test (owner,database,schema,tablename);
proc sql;
connect to oracle (AUTHDOMAIN=ORACLE_&OWNER._&database. PATH=&database. readbuff=1000);
execute(
DECLARE
tbl_count number;
string varchar2(100) :='test &tablename.'
DBMS_OUTPUT.PUT_LINE(string);
) BY ORACLE;
DISCONNECT FROM ORACLE;
quit;
%mend test;
%test(&owner., &Database.,&schema.,&TblName2.);