I am trying to copy data from CAS (in memory table) to SQL. I haven't been successful. I have narrowed down the problem - I can't even replicate the table into another CAS Table. The data is not that big. I am trying to write 16m rows with two columns. It disconnects at approx. 8m rows. The log doesn't populate with an error (the log clears) and my session simply disconnects. I have gradually increased the obs, and at approx. 8m it stops working.
data public.test2; set public.test1 (datalimit = all obs=10000000); run;
The log doesn't display anything:
I have previously been able to do this with 3.4 (in fact much larger data sets - many more rows and columns). We have recently upgraded to 3.5 and since then it doesn't work. There is plenty of memory available.
Does anyone have an idea? Is there maybe a setting in cas management?
Funny, but this morning I can copy from CAS table to CAS table. I still can't copy to work (spre). I used the CASClientDebug, but the log is still empty - the session completely disconnects.
I will get the logs and send it to you.
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.
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.