Does RServer support the creation of temporary table while pulling the data from database.

General
1

Right now we are using the SAS ( proc sql ) to pull the data from database and it allows to create the temporary table.

Similarly does R Server supports the creation of temporary tables as we have in SAS.

Syntax used in SAS to create the temporary table:

Create temp table tablename as select * from [existing table from database ].

As we are looking for SAS (proc sql) code to the other platform which support creation of temporary table.

Please Note: After pulling the data from SAS we are the R Studio IDE to further work on to the solution.

2

I'm almost sure that functionality is implemented by the sql server not by SAS so you can also send the same sql command from R and it would get executed on the sql server.

3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.