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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: