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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.