Dear Experts,
My SAS 9.4 version going to expire on this week.
So I created an account in SAS University edition and that works well.
The Issue is - SQL connection.
I used the below code on SAS 9.4v for SQL server connectivity
Libname Proj ODBC NoPrompt="Driver=SQL Server;Server=192.168.21.3;Database=Project;UID=***;PWD=***";It perfectly replicates the exact SQL Database, but It fails on the SAS University edition.
University Edition LOG:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 Libname Proj ODBC NoPrompt="Driver=SQL Server;Server=192.168.21.3;Database=Project;UID=***;PWD=***";
ERROR: The product with which the engine ODBC is associated is either not licensed for your system or the product license has
expired. Please contact your SAS installation representative.
ERROR: Error in the LIBNAME statement.
74
75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
87 Is there any chance to connect my SQL server in SAS University edition.
Thanks for any hints
Afaik SAS UE can't connect to databases.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.