topic Re: increasing memory block size in session option in SAS Viya in Administration and Deployment

increasing memory block size in session option in SAS Viya

touwen_k — Wed, 21 Sep 2022 15:29:26 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: increasing memory block size in session option in SAS Viya

jklaverstijn — Tue, 27 Sep 2022 11:15:21 GMT

Not in a position to test right away, but what about enclosing the alphanumerical values in quotes?

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

regards,

- Jan.

Re: increasing memory block size in session option in SAS Viya

touwen_k — Fri, 30 Sep 2022 08:24:41 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.

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;