How to get table size using proc sql

[VijayKumar]

Hi  Experts,

Could you please tell me the proc sql query in SAS  that will output the size of a table(in MB or GB)  in SAS ?

[LinusH]

By querying the SAS dictionary, you could get a approximate figure.

If the table is compressed, or has index, it's getting a bit more complex.

If you have tables in BASE engine you could read the OS information, pipe it back to (but this wouldn't be SQL).

[LinusH]

Sorry, forget sample code:

proc sql;

create table tab as

select libname, memname, nobs, obslen, nobs*obslen as Bytes

from dictionary.tables

where libname='YOURLIB';

quit;

[jvp7]

I want to know how to calculate the file size if the table has index. Could you help me, please?

[Tom]

proc sql ;

  select libname,memname,filesize,pcompress

  from dictionary.tables

;

quit;

[AllanBowe]

It's not a SQL query but it is a macro function - https://core.sasjs.io/mf__getfilesize_8sas.html

Usage: %put %mf_getfilesize(libds=work.yourdataset,format=yes);

[JackHamilton]

Does it have to be in PROC SQL? PROC CONTENTS will give you that information as well.