how to push sas Data set in to SQL server(RTest- SQl R)
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
There are literally thousands of examples online, start with SAS/ACCESSS documentation.
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
actually im connecting R- software with SQL server(Library name is -RTest ) and i wnat to push the sas data set to SQL server
-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.
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.