topic Re: How to get table size using proc sql in SAS Programming

How to get table size using proc sql

VijayKumar — Thu, 05 Sep 2013 12:32:26 GMT

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 — Thu, 05 Sep 2013 12:59:52 GMT

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 — Thu, 05 Sep 2013 13:06:23 GMT

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;

Tom — Thu, 05 Sep 2013 17:20:21 GMT

proc sql ;

select libname,memname,filesize,pcompress

from dictionary.tables

;

quit;

jvp7 — Wed, 30 Sep 2020 10:15:59 GMT

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

AllanBowe — Tue, 30 Nov 2021 15:00:46 GMT

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 — Tue, 30 Nov 2021 22:25:10 GMT

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