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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.