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 ?
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).
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;
I want to know how to calculate the file size if the table has index. Could you help me, please?
proc sql ;
select libname,memname,filesize,pcompress
from dictionary.tables
;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.