Desktop productivity for business analysts and programmers

assign sql database as a library in SAS EG

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

assign sql database as a library in SAS EG

Hi Team , 

I am trying to assign the below database on a SQL server as a library in sas.  I need to pass in user name and password as well..


Server : MELMD0226

 

database : Boss_Logging

 

Table : dbo.sales

 

Could you please advice how this can be achived ..

 

Regards

Shiva 

 


Accepted Solutions
Solution
‎07-13-2017 10:42 PM
Contributor
Posts: 44

Re: assign sql database as a library in SAS EG

I got the working solution .. thanks team ..

 

 

 

libname databa odbc complete="driver=SQL Server;
user=XXXXX;
pwd=XXXXXXXX;
database=Boss_Logging;
Server=MELMD0226"
schema=dbo;

View solution in original post


All Replies
Solution
‎07-13-2017 10:42 PM
Contributor
Posts: 44

Re: assign sql database as a library in SAS EG

I got the working solution .. thanks team ..

 

 

 

libname databa odbc complete="driver=SQL Server;
user=XXXXX;
pwd=XXXXXXXX;
database=Boss_Logging;
Server=MELMD0226"
schema=dbo;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 131 views
  • 0 likes
  • 1 in conversation