BookmarkSubscribeRSS Feed
JMarkW
Fluorite | Level 6
I'm looking details on how to utilize Oracle Stored Procedures using SAS. The only info I've found so far is:
---------------------------------------------
PROC SQL ;
CONNECT TO DBMS-NAME <( )>;
DISCONNECT FROM DBMS-NAME | ALIAS;
EXECUTE (DBMS-SPECIFIC-SQL-STATEMENT) BY DBMS-NAME | ALIAS;
SELECT COLUMN-LIST FROM CONNECTION TO DBMS-NAME | ALIAS (DBMS-QUERY)
EXAMPLE
proc sql;
connect to oracle (user= &user password= &PWD path= &PATH ) ;
exec(alter table official_index disable constraint FK1_INDEX_SID) by oracle;
exec(truncate table official_index) by oracle;
exec (alter table official_index enable constraint FK1_INDEX_SID) by oracle;
disconnect from oracle ;
quit;
Note that when you want to execute a stored procedure you need to specify
Exec (exec stored_procedure) by oracle;
--------------------------------------------

Does anybody know of a good manual or other resource?
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Suggest searching the SAS support website http://support.sas.com/ using your keyword references. Here is one of several hits found.

Scott Barry
SBBWorks, Inc.

Usage Note 18350: Calling Stored Procedures using SAS/ACCESS Interface to Oracle
http://support.sas.com/kb/18/350.html

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
  • 1 reply
  • 729 views
  • 0 likes
  • 2 in conversation