Embedding a LIBNAME statement inside PROC SQL makes no sense. Move it to open code. Also not sure why you need both a libname DB connection and also an SQL passthru DB connection. What does your complete code look like?
%macro exsetup
%put &sysuserid;
libname l123 oracle user=<<username>> password=<<password>> path=<<service>>
dbconinit = "begin pkg.procedure_name(1234); end;";
proc sql;
connect to oracle(path=<<service>> user=<<username>> password=<<password>>);
quit;
%mend exsetup;
%exsetup;
... View more