topic how to push sas Data set into SQL server in SAS Programming

how to push sas Data set into SQL server

sivastat08 — Fri, 10 Mar 2017 08:14:59 GMT

how to push sas Data set in to SQL server(RTest- SQl R)

Re: how to push sas Data set into SQL server

LinusH — Fri, 10 Mar 2017 08:18:58 GMT

There are literally thousands of examples online, start with SAS/ACCESSS documentation.

Re: how to push sas Data set into SQL server

sivastat08 — Fri, 10 Mar 2017 08:20:44 GMT

thanks LinusH.

Re: how to push sas Data set into SQL server

JuanS_OCS — Fri, 10 Mar 2017 08:22:49 GMT

Hello @sivastat08,

while I cannot understand the remark of "RTest- SQl R". to move data from a SAS dataset to any other data origin, such as SQL server you will need:

- the license for SAS/ACCESS interface to (your data source) (SQL Server, or ODBC. You can get also OLEDB, but I would rather advise against it, unless you have a very specific requirement).

- to install that SAS software component

- to install and configure the drivers for the SQL Server on the client and the server (if required)

- you use the appropiate libname statement in your code

- use a data step or proc sql, as with any other table

Re: how to push sas Data set into SQL server

user24feb — Fri, 10 Mar 2017 08:24:57 GMT

You probably are supposed only to insert data (and not to create tables). Could be something like:

Proc SQL;
  Insert Into <SQL.Table> Select * From <SAS.Table>;
Quit;

Re: how to push sas Data set into SQL server

sivastat08 — Fri, 10 Mar 2017 08:28:31 GMT

actually im connecting R- software with SQL server(Library name is -RTest ) and i wnat to push the sas data set to SQL server

Re: how to push sas Data set into SQL server

Kurt_Bremser — Fri, 10 Mar 2017 08:49:35 GMT

-Rtest is not a valid SAS name.

Please specify how you access the R data from SAS and which libname statement you use for SQL Server.