How to get the size of a table in CAS?

[smm662002]

Hello,

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

Thank you,

Madalin

[miaeyg]

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

[smm662002]

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

[miaeyg]

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

[AmrAlmaz]

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;