topic Re: CAS disk space issue in SAS Programming

CAS disk space issue

phopkinson — Mon, 22 Jul 2024 13:09:07 GMT

Hi all,

I am currently having an issue with disk space in SAS when using CAS, unfortunately there is no option to increase the disk space. So wanted to know what I could do to reduce the file size in CAS and if there are any process that will help, so basically small overview of what I am trying to do - i am loading 4 datasets into the CAS area and then joining them using a proc fedsql. This process did work with only three datasets, but now I have added the fourth it is problematic.

Thanks in advance.

Re: CAS disk space issue

Sajid01 — Mon, 22 Jul 2024 14:01:43 GMT

Hello
In the event one cannot add hardware resources, the feasible option to re examine the code /algorithm.
Look for alternative approaches to accomplish the same task.

Re: CAS disk space issue

sbxkoenk — Mon, 22 Jul 2024 14:09:48 GMT

Your issue is probably related to CAS_DISK_CACHE being too small.

If you are using Viya 4, you can switch memory-format from standard to DVR (Duplicate Value Reduction).

Duplicate Value Reduction is a powerful "memory format" for CAS tables that significantly reduces their size.

It makes the tables less big WITHOUT performance impact.

( Compression can also be done, but that has definitely a performance impact )

Viya 2020.1: CAS ‘Duplicate Value Reduction’

Posted 12-18-2020 02:14 PM | by StephenFoerster

https://communities.sas.com/t5/SAS-Communities-Library/Viya-2020-1-CAS-Duplicate-Value-Reduction/ta-p/707049

CAS: Making DVR the Default

Posted 08-26-2022 10:50 AM | by StephenFoerster

https://communities.sas.com/t5/SAS-Communities-Library/CAS-Making-DVR-the-Default/ta-p/830612

Koen

Re: CAS disk space issue

phopkinson — Mon, 22 Jul 2024 14:44:42 GMT

Thank you Koen, that is really useful.