topic How to get the size of a table in CAS? in SAS Viya

How to get the size of a table in CAS?

smm662002 — Wed, 11 Aug 2021 10:09:12 GMT

Hello,

Can anybody advise which is the most accurate method to get the size of a table in CAS?

Thank you,

Madalin

Re: How to get the size of a table in CAS?

miaeyg — Wed, 11 Aug 2021 11:34:06 GMT

Hi,

I think this is what you are looking for: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/caspg/cas-table-tabledetails.htm?homeOnFail

Eyal

Re: How to get the size of a table in CAS?

smm662002 — Wed, 11 Aug 2021 13:24:40 GMT

Hi Eyal,

Thank you for your reply.
CAS action table.tableDetails provides two useful columns "Data size" and "Variable Data size".
Would you know if table size is the sum of "Data size" and "Variable Data size"?

Thank you,
Madalin

Re: How to get the size of a table in CAS?

miaeyg — Fri, 13 Aug 2021 13:22:08 GMT

Hi @smm662002

Yes, I believe you need to sum the two. One if "fixed" size columns and the other is "variable" sized columns like varchar.

HTH,

Eyal

Re: How to get the size of a table in CAS?

AmrAlmaz — Wed, 05 Nov 2025 08:01:19 GMT

Here you go.

/*Set without quotations the libname variable to the library name and the dsname variable to the dataset name which you want to inquire about it's size*/

%let libname=?;

%let dsname=?;

/*Initiate CAS session*/

cas;

/*Use table.tabledetails to get the table size and save the result to work.cas_ds_memsize dataset*/

proc cas;

table.tabledetails result=res/ caslib="&libname." NAME="&dsname." showmem=true;

saveresult res dataout=work.cas_ds_memsize;

quit;

/*Query work.cas_ds_memsize dataset to display the size in megabyte (MB)*/

proc sql;

select

"&libname." as CAS_Library_Name,

"&dsname." as CAS_Dataset_Name,

(mem.MappedMemory/1024/1024) format=8.2 as Memsize_MB

from

work.cas_ds_memsize mem

;

quit;