BookmarkSubscribeRSS Feed
bob021
Calcite | Level 5

Hi to All

Can somebody tell me how to call stored procedure in SAS?

I try with this but i received Error in the LIBNAME statement

libname mydblib odbc dsn=CC_DB_live user=**** password=**** dbconinit='call SP_WT_REPORT'

Thank you in advance.

Bob

2 REPLIES 2
shivas
Pyrite | Level 9

Hi ,

Try this...hope it helps...

proc sql;

    connect to oledb(dsn=CC_DB_live  uid=test pwd=test provider=sqloledb);

           execute (SP_WT_REPORT ) by oledb;

quit;

Thanks,

Shiva

bob021
Calcite | Level 5

Hi

Thank you for respond.

I recieved this error

ERROR: The OLEDB engine cannot be found.

ERROR: A Connection to the oledb DBMS is not currently supported, or is not installed at your site.

Thank you again

Bob

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 826 views
  • 3 likes
  • 2 in conversation