Help using Base SAS procedures

Call stored procedure odbc

Reply
Contributor
Posts: 60

Call stored procedure odbc

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

Super Contributor
Posts: 349

Re: Call stored procedure odbc

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

Contributor
Posts: 60

Re: Call stored procedure odbc

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

Ask a Question
Discussion stats
  • 2 replies
  • 252 views
  • 3 likes
  • 2 in conversation