I successfully allocated a libname to my SQL Server 2014 instance from SAS 9.4M3 on 64-bit Windows 10 using
libname sql odbc dsn='SQLServer' user=sas_readonly pw=MyPassword;
No joy however as there were no tables upon opening the library.
So...I added the SCHEMA='DBO' option.
Opening the library again the DataDirect warning displays continuously. Selecting 'OK' does not close it.
OK. Joy. I changed the libname statement to
libname sql sqlsvr dsn='SQLServer' user=sas_readonly pw=MyPassword schema='dbo';
and no more popup...and I can see my tables. Case closed.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.