topic Re: Can we write a table to an excel to a local file, when running the code within Rsubmit? in SAS Programming

Can we write a table to an excel to a local file, when running the code within Rsubmit?

Santt0sh — Fri, 14 Oct 2022 18:44:00 GMT

Hi All,

I am trying to create a report. Here we are dealing with daily data, and millions of sales transactions (i.e. daily, monthly, Qtrly ) We are creating the Temp tables (Volatile tables(Teradata) ) and calculating the required variables and outputting it to SAS (.lst file) but now need to create a report with some additional formatting and I am aware that we cannot directly refer the local path or my path(d:/qtr/sales/).

Can you please suggest me on this?

Regards.

Re: Can we write a table to an excel to a local file, when running the code within Rsubmit?

PaigeMiller — Fri, 14 Oct 2022 19:19:53 GMT

Why create the .lst file? Why not just store the data in a SAS data set and then do the report in SAS?

Re: Can we write a table to an excel to a local file, when running the code within Rsubmit?

Santt0sh — Fri, 14 Oct 2022 19:25:07 GMT

Hi,
Thank you for your quick response!

I tried creating the datasets, as we are dealing with huge sales transactions the creation of datasets is taking longer than anticipated hence trying to do the calculations on the fly.

Rgs

Re: Can we write a table to an excel to a local file, when running the code within Rsubmit?

Reeza — Fri, 14 Oct 2022 19:25:26 GMT

If your server has access to the local directory yes. Is that likely, no.

Usually you would do the work and analysis on the server, bring back the data prepared to the local version and use that for reporting. The server is typically provisioned to handle bigger data, with more RAM and CPU than your local installation. And controlled access. It processes the data.
Exactly how you do that depends on your set up.

Re: Can we write a table to an excel to a local file, when running the code within Rsubmit?

PaigeMiller — Fri, 14 Oct 2022 19:40:36 GMT

We are creating the Temp tables (Volatile tables(Teradata) ) and calculating the required variables and outputting it to SAS (.lst file)

...

I tried creating the datasets, as we are dealing with huge sales transactions the creation of datasets is taking longer than anticipated hence trying to do the calculations on the fly.

None of us really knows what you are doing, what calculations you are doing, what report you are going to be creating. So its really hard to be more specific.

Some SAS procedures can work "in the database" rather than work in SAS, and so many of the calculations (depending on what calculations you need) could be done that way, and this could be a lot faster than whatever you are doing. For example, PROC SUMMARY/PROC MEANS docs say

In-Database Processing for PROC MEANS

When large data sets are stored in an external database, the transfer of the data sets to computers that run SAS can be impacted by performance, security, and resource management issues. SAS in-database processing can greatly reduce data transfer by having the database perform the initial data aggregation.