topic Re: Proc SQL pass-through change from Oracle to SQL Server in SAS Procedures

Proc SQL pass-through change from Oracle to SQL Server

Datino — Mon, 13 Apr 2020 15:06:43 GMT

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?

Re: Proc SQL pass-through change from Oracle to SQL Server

argerapor — Mon, 13 Apr 2020 15:36:43 GMT

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

Re: Proc SQL pass-through change from Oracle to SQL Server

SASKiwi — Mon, 13 Apr 2020 21:21:30 GMT

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?

Re: Proc SQL pass-through change from Oracle to SQL Server

argerapor — Tue, 14 Apr 2020 01:48:00 GMT

ı problem solved:

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