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?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: