SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
Scottcom4
Calcite | Level 5
Hi Guys,

At present we have SQL set up which allows us to access an Oracle DB via OLEDB (my understanding, but the code is attached to better explain). The thing is that I would like to establish a libname for this connect, so that I can see the tables contained within.

I have code to do this for a genuine Oracle connection, but can't get it to work in this instance.

Would anyone have any ideas on this?

Thank you in advance.

proc sql;
connect to oledb as oradb (User = XXXXXXXX Password = XXXXXX DataSource = XXXXXXXXXXXXX provider = MSDAORA.1);;
create table list_tab as
select * from connection to oradb
(select OWNER, TABLE_NAME from ALL_TABLES);
quit;
1 REPLY 1
Scottcom4
Calcite | Level 5
I have been looking on the internet for hours and didn't find anything about this issue, however 5 minutes after I posted this problem I located a SUGI containing the information I was after.

However, only 90% of the tables contain data. The 10% results in the folowing error message

[ERROR] Prepare error: ICommand Prepare::Prepare Failed. SQL Statement SELECT * From CBMRV_CLAIM.

I get a similar issue when attemtion to use SQL pass through using the SELECT *, however once (a very manual method of trawling through and adding one variable at a time) I remove the offending variable it works perfectly.

Does anyone have any ideas?

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 741 views
  • 1 like
  • 1 in conversation