I am using SAS and have my proc sql; statement and my connection statement however when I run all the way to the disconnect and quit I get this error:
The DB2 engine cannot be found
A connection to the DB2 DBMS is currently not supported or not installed on your site.
I have tried to go through the documentation to see if I can figure out how to fix it but not having any success. I suspect that my desktop support folks did not load or connect something correctly when loading my SAS. Any advice?
Which way are you using to connect DB2?
ODBC or SAS/Access to DB2. But both of ways need you to installl DB2 customer software firstly.
From your log, it looks like you don't set up it.
Ksharp
If you search the SAS support site for your problem you will find many references to your problem including this:
http://support.sas.com/kb/20/510.html
So it could be SAS/ACCESS to DB2 is not licensed. Run PROC SETINIT to check if it is or not.
Here's another easy way to see what SAS products you have licensed/installed.
In the Server List window, expand the SAS server you want to check (for example, SASApp). Right-click on the server icon and select Properties.
In the Properties window, select the Software tab. Then click View SAS Server Products. The SAS Server Products window appears, like so:
It's not an exhaustive list of all products, but it does cover the most common set.
Chris
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.