I have created a program to load the data to update the table in cas as in-memory but while job is executing the report show no data source, then after executing the job if I refresh the report then message disappears.
how to avoid this error while updating the cas table users will be using the report so they should not effect.
Let's test it out using a sample dataset with 100 million rows:
caslib _ALL_ assign;
do i = 1 to 100000000;
Checking the log, this took about 21 seconds to load to CAS:
NOTE: There were 100000000 observations read from the data set WORK.HAVE.
NOTE: The data set CASUSER.HAVE has 100000000 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 20.83 seconds
cpu time 18.45 seconds
Let's take this table that's already in CASUSER and promote it to Public:
NOTE: Cloud Analytic Services promoted table HAVE in caslib CASUSER to table have in caslib public.
NOTE: The Cloud Analytic Services server processed the request in 0.160539 seconds.
It didn't even take one second to move the data between caslibs! If reducing downtime is your goal, loading to CASUSER first and then promoting to your final caslib is the way to go. Just be sure you have the memory to do it.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.