BookmarkSubscribeRSS Feed
Datino
Obsidian | Level 7

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?

3 REPLIES 3
argerapor
Calcite | Level 5
Right click on Explorer screen and select new.
Select odbc in engine section. Enter username and password. Did it happen this way?
this is the library but I don't know what to do next
SASKiwi
PROC Star

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?

argerapor
Calcite | Level 5

ı problem solved: 

 

LIBNAME Newlib ODBC NoPrompt="Driver={SQL Server}; Server=xservernamex; Database=xdbnamex; user=; pwd=";

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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!

Register now

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1286 views
  • 0 likes
  • 3 in conversation