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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.