proc sql;
connect to oracle (user=myusr1 password=mypwd1);
select *
from connection to oracle
(select * from table
disconnect from oracle;
quit;
How to enable oracle engine in and connect in SAS EG IN SAS ON DEMAND
On Demand does not provide SAS/ACCESS to Oracle.
PS: you determine this by running PROC SETINIT.
which database can we connect Mysql can enable in SAS EG in SAS ondemand
proc setinit; run; will tell you what's licensed
proc product_status; run will tell you what's installed.
If SAS/Access to ODBC is installed then you should "theoretically" be able to connect to Oracle once you've done all the configuration work. But not sure what sort of connectivity the SAS On Demand version allows.
And if a suitable module is found, the documentation will tell you how to use it. Oracle, MySQL and a slew of others fall under "Relational Databases".
Mind that connecting to databases is way beyond trivial; it takes thorough knowledge of the DB in question and the necessary SAS parts. On top of that, a client for the DB in question must be installed and configured on the SAS server.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.