In Viya 4 LTS 2025-03 it is not possible to add to flow a local file that could be automatically loaded once again in new session. SAS could add similarly to Enterprise Guide a valid object that could be automatically reloaded from local filesystem for data processing. Currently all local files must be uploaded manually and there is no possibility to automate such a file delivery without some custom solutions like Python scripts. SAS Studio should be able to load a local filesystem file automatically from flow.    ... View more

ODS Excel - The SAS System stopped processing this step because of insufficient memory. We face an issue with ODS Excel, that to format it and export around 100 000 rows we need to extend session memory to 20GB!!! Sample code below already consumes on Viya 4 LTS 2025-03 1,2GB. When using openpyxl python library it can be much more efficient. I think in best SAS interested is to make export to Excel efficient and modern. I hope this procedure can be just modernized and become more efficient . I tried to use MS Office Add-in but it can't be automated and after reloading table all filters are gone 😞 SAS is aware about this issue: https://sas.service-now.com/csm/en/an-out-of-memory-condition-might-occur-when-you-use-the-ods-destination-for?id=kb_article_view&sysparm_article=KB0036290 and actually do nothing to improve this procedure.    filename outfile "path/output_file2.xlsx"; ods excel file=outfile style = HTMLBlue    options(sheet_name = "test"     autofilter = "yes"    frozen_headers = "1");   proc report data = sashelp.prdsal2  style(header)=[backgroundcolor=white fontweight=bold textalign=left]; run;   ods excel close;   Error for larger files:  ERROR: The SAS System stopped processing this step because of insufficient memory. ... View more