DATA Step, Macro, Functions and more

dbconinit calling dabase procedure 2 times for for one execution

Reply
Occasional Contributor
Posts: 11

dbconinit calling dabase procedure 2 times for for one execution

I am using the below code to call a DB procedure from Sas. Sas is calling the procedure 2 times for one execution. Please help why it is calling the procedure 2 times.

 

%macro exsetup

%put &sysuserid;

proc sql;

connect to oracle(path=<<service>> user=<<username>> password=<<password>>);

libname l123 oracle user=<<username>> password=<<password>> path=<<service>>

dbconinit = "begin pkg.procedure_name(1234); end;";

quit;

%mend exsetup;

%exsetup;

Super User
Posts: 3,775

Re: dbconinit calling dabase procedure 2 times for for one execution

Posted in reply to ajaybetham

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;

 

Ask a Question
Discussion stats
  • 1 reply
  • 74 views
  • 0 likes
  • 2 in conversation