topic Re: pushing sas dataset into SQL Server in SAS Programming

pushing sas dataset into SQL Server

VJ1 — Wed, 28 Dec 2016 14:18:05 GMT

Hi,

I have a sas data set. what I need to do is to push that dataset into SQL Server with new table name in SQL Server. can someone please help me in doing this ? it would be very helpful if someone provide the code for this.

I haven't used sas before but I have access to SAS and also I have access to Read & write data in SQL Server.

Thanks,

Re: pushing sas dataset into SQL Server

ccaulkins9 — Wed, 28 Dec 2016 14:45:28 GMT

Have you looked at the PROC SQL examples in the online documentation?

Re: pushing sas dataset into SQL Server

VJ1 — Wed, 28 Dec 2016 14:52:35 GMT

No I haven't looked those. what i am looking is to push the dataset into SQL server using sas. since I don't know SAS I am looking for SAS Code for this. can you provide that ?

Re: pushing sas dataset into SQL Server

error_prone — Wed, 28 Dec 2016 15:59:53 GMT

proc sql is a sas procedure.

The data you want to store in the database is currently stored in sas datasets?

Re: pushing sas dataset into SQL Server

Reeza — Wed, 28 Dec 2016 16:03:39 GMT

Set up a odbc connection to the server via control panel.

https://support.sas.com/techsup/technote/ts765.pdf

Assign a libname to the server and then a simple dataset or proc datasets can be used to create the table.

libname sqlsrv odbc dsn=myserv schema=dbo;

data sqlsrv.data;

set data;

run;

Re: pushing sas dataset into SQL Server

AhmedAl_Attar — Wed, 28 Dec 2016 16:15:51 GMT

VJ,

Do you know which version of

- SAS Software you have?

- Which SAS/ACCESS product you have (SAS/ACCESS to OLE DB/ODBC)?

Once you have answered the above two questions, then you can find sample code in the relavant documentation here

SAS/ACCESS 9.x for Relational Databases: Reference,

Note: There are no single code that works for all databases, therefore you shouldn't count on someone to provide you a working code for your database! Read the doc and adopt the code to your settings and environment.

Hope this helps,

Ahmed