order data sets by file size

[Ronein]

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;

[PeterClemmensen · Accepted solution]

Use the SIZEKMG Format

[Ronein]

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;

[Kurt_Bremser]

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