Copying SQL table to SAS

ammarhm — Wed, 17 Mar 2021 08:34:55 GMT

Hi everyone,

i would really appreciate your help in solving an issue connecting to SQL database. Basically I am trying to copy the table 'Lab' which is stored in a SQL server 'Hospital' under database 'Results'.

The SQL server is hosted on a network connected machine. I have trusted connection to the SQL server, s basically if I login into windows with my credentials and start Microsoft SQL management studio then i can directly connect to the SQL server 'Hospital' and view the database 'Results' with its tables including Lab.

I want to copy the table 'Lab' into SAS for processing.

I tried usin the following code:

Libname SQL_Lib ODBC NoPrompt="Driver=SQL Server;Server=Hospital; Database=Results;  schema = dbo; Trusted_Connection=Yes";

This does not generate an error, however when i double click on the new library in SAS explorer window, there are no contents inside the library and I do not know if there is anything wrong with my code or if i should be using a code (which?) to copy the table without worrying about the absence of contents in the library.

Any help is much appreciated.

Re: Copying SQL table to SAS

ChrisNZ — Wed, 17 Mar 2021 10:31:17 GMT

Try that.

proc copy in=SQL_LIB out=WORK; select LAB; run;

topic Copying SQL table to SAS in SAS Programming

Copying SQL table to SAS

Re: Copying SQL table to SAS