I just downloaded and installed SAS/ACCESS Interface to ODBC. I'm running SAS 9.4 on Windows 64 bit machine.
My task is to connect to a live oracle database (known as Powerschool).
The IT dept gave me this info (changed to nonsense in this post):
datasrc=fakesource user=fakeuser password=fakepw;
SAS LOG
libname mydblib odbc datasrc=fakesource user=fakeuser password=XXXXXXXXXX;
ERROR: The ODBC engine cannot be found.
ERROR: Error in the LIBNAME statement.
10 proc product_status;run;
For Base SAS Software ...
Custom version information: 9.4_M5
Image version information: 9.04.01M5P090617
For SAS/STAT ...
Custom version information: 14.3
For SAS/GRAPH ...
Custom version information: 9.4_M5
For High Performance Suite ...
Custom version information: 2.2_M6
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M5
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
real time 0.17 seconds
cpu time 0.03 seconds
Suggestions? I've never had this module before.
did you create an ODBC reference on the workstation?
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.