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
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.