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.