how to display the macro variable value in dbms_output.put_line(string)

alepage — Mon, 05 Feb 2024 21:32:58 GMT

%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.);

Re: how to display the macro variable value in dbms_output.put_line(string)

Patrick — Tue, 06 Feb 2024 00:27:13 GMT

@alepage Did you already see this discussion?

topic how to display the macro variable value in dbms_output.put_line(string) in SAS Enterprise Guide

how to display the macro variable value in dbms_output.put_line(string)

Re: how to display the macro variable value in dbms_output.put_line(string)