topic Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory in SAS Studio

cas sessopts for MAXTABLEMEM to load larger blocks of memory

touwen_k — Wed, 21 Sep 2022 15:27:02 GMT

Dear SAS community,

I would like to know how to use MAXTABLEMEM in a code in SAS Studio in SAS Viya, I was trying like that :

cas mySession sessopts=( caslib=casuser timeout=1800 locale="en_US" MAXTABLemem=8G);

But it gives error:

ERROR: The syntax for CASSESSOPTS requires specification of one or more name=value combinations. The entire set of combinations
must be within parenthesis.

Pls advise.

Karolina

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

Mike_j — Thu, 06 Oct 2022 09:41:35 GMT

Hi Karolina,

I believe you need to put the 8G in plings like below:

cas mySession sessopts=( caslib=casuser timeout=1800 locale="en_US" MAXTABLemem="8G");

Mike

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

touwen_k — Fri, 07 Oct 2022 08:17:31 GMT

Thank you, then cas accepts it. However when running this code below for different MAXTABLemem, I do not have a different number of blocks. Therefore I do not know if cas is really changing the size of the blocks. Pls advise.

It can be any table you have loaded to memery, important part of code is as below, it gives info about the memory blocks.
table.tableInfo / table="iris";
table.tableDetails / table="iris"
------------------------------------------------------------------
proc cas;
session casauto;

/* Load source data (IRIS) into a table. */
table.loadTable /
path="iris.sashdat"
casout={name="iris"};
run;

table.tableInfo / table="iris";
table.tableDetails / table="iris";
quit;

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

touwen_k — Fri, 07 Oct 2022 08:18:50 GMT

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

Mike_j — Fri, 07 Oct 2022 08:29:53 GMT

I am a bit unsure what it is you want to accomplish.

Do you want to distribute the dataset across worker nodes differently? load the dataset to a single worker node? something else?

Here is a link to an article that describes the maxtablemem in more details:

Dr. StrangeRAM or: How I learned to stop worrying and love CAS - SAS Users

Mike

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

touwen_k — Fri, 07 Oct 2022 08:58:14 GMT

Thank you for the article, I could not find much about the memory blocks. I have read that when loading a large table, it is recommended to set block from 16MB to larger. This can be done in session options with quotation marks as you advised.
How to check that this option works, that it is changed from 16 MB to 256MB, with which commando? If I suggested a wrong commando, it is because I do not know which one to use.

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

Mike_j — Fri, 07 Oct 2022 10:18:28 GMT

Okay, in that case you can use below code snippet to check the options in a session:

cas cas1 sessopts=(maxtablemem="16M");                                     
proc cas;
   session cas1;
   sessionProp.listSessOpts result=r;             
run;
   print r.SessOpts[, {"Name", "Type", "Value"}]; 
run;
quit;

cas cas2 sessopts=(maxtablemem="32M");
proc cas;
   session cas2;
   sessionProp.listSessOpts result=r;             
run;
   print r.SessOpts[, {"Name", "Type", "Value"}];
run;
quit;

You should see that the output varies for sessions with different values of the maxtablemem option.

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

touwen_k — Fri, 07 Oct 2022 11:13:59 GMT

Thank you very much for providing clarity on this topic. It works.

Re: cas sessopts for MAXTABLEMEM to load larger blocks of memory

Mike_j — Fri, 07 Oct 2022 11:15:49 GMT

Perfect. Glad I help!