topic Re: order data sets by file size in SAS Programming

order data sets by file size

Ronein — Mon, 19 Aug 2024 09:10:25 GMT

Hello

I want to see all data sets and views in library R_R

I want to order them by file size.

I run this code but in output it is not so clear what is file size because the numbers are with E format

proc sql;
title 'All Tables and Views in the SQL Library';
select  libname, memname, memtype, nobs, filesize 
from dictionary.tables
where libname='R_R'
order by filesize desc 
;
quit;

Re: order data sets by file size

PeterClemmensen — Mon, 19 Aug 2024 09:32:12 GMT

Use the SIZEKMG Format

Re: order data sets by file size

Kurt_Bremser — Mon, 19 Aug 2024 09:48:54 GMT

Make it a habit to always assign a suitable format when creating numeric variables.

Re: order data sets by file size

Ronein — Mon, 19 Aug 2024 16:55:38 GMT

Do you mean

put(filesize,sizekmg.) as filesize

It looks great now!!!

proc sql;
title 'All Tables and Views in the SQL Library';
select  libname, memname, memtype, nobs, 
put(filesize,sizekmg.) as filesize
from dictionary.tables
where libname='R_R'
order by filesize desc 
;
quit;