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.
Why create the .lst file? Why not just store the data in a SAS data set and then do the report in SAS?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.