how to push sas Data set into SQL server

[sivastat08]

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

[LinusH]

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

[sivastat08]

thanks LinusH.

[JuanS_OCS · Accepted solution]

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

[sivastat08]

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

[Kurt_Bremser]

-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.

[user24feb]

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;