Hello,
I have code that looks like this:
PROC SQL; CONNECT TO ORACLE (PATH=ORCL user="user" password="password123");
How do I change it to use a SQL Server data base instead of Oracle?
What SAS/ACCESS product are you using for SQL Server? ACCESS to SQL Server or ACCESS to ODBC? What OS does your SAS software run on?
ı problem solved:
LIBNAME Newlib ODBC NoPrompt="Driver={SQL Server}; Server=xservernamex; Database=xdbnamex; user=; pwd=";
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 save with the early bird rate—just $795!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.