Hello Folks,
I want to pass Multiple parameters(say like 3, one of them should be a null value) to a Procedure that is stored in Oracle. I want to run this procedure through SAS 9.3.
I can pass single parameter using the below method
proc sql;
connect to oracle (user=userid password=password path=database_name);
execute (execute st_pr_name('parm')) by oracle;
disconnect from oracle;
quit;
However, i can't run the procedure with Multiple input Parameters. Can someone help me out with an example ?
Thanks,
Pavan
This isn't a SAS issue it is an Oracle syntax issue. A quick Google search suggests you use multiple parameters like this:
proc sql;
connect to oracle (user=userid password=password path=database_name);
execute (execute st_pr_name(parm1, parm2, parm3)) by oracle;
disconnect from oracle;
quit;
This isn't a SAS issue it is an Oracle syntax issue. A quick Google search suggests you use multiple parameters like this:
proc sql;
connect to oracle (user=userid password=password path=database_name);
execute (execute st_pr_name(parm1, parm2, parm3)) by oracle;
disconnect from oracle;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.