How to load table from sas program or sas flow to in memory database in sas to use it in reports ?
Base SAS: load table into memory and utilize back from memory using data _null_. Try below code.
SAS Viya: Please refer to link
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/casref/p0pw2zomel6mfan1iutjd85rrhn9.htm
data _null_;
set work.mytable;
run;
sasfile work.mytable load;
data _null_;
set work.mytable;
run;
Are you asking about loading the table into memory in the CAS server or the LASR server? Which version of SAS Visual Analytics are you using?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.