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