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=";

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 1056 views
  • 0 likes
  • 3 in conversation