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

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.

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.

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