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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.