Good afternoon I have a library and there are tables, how can I find out the table size in sas guide

[Satora_In]

Good afternoon
I have a library and there are tables, how can I find out the table size in sas guide or sas console?

[Kurt_Bremser]

PROC CONTENTS will tell you the size,both in terms of observation numbers and physical file size.

You can also query DICTIONARY.TABLES in PROC SQL.

[Satora_In]

You misunderstood, I want know size table in the library. How I can use the SQL? Could you write example

[Kurt_Bremser]

If I misunderstood you, write a more clear and detailed question.

[Satora_In]

I want to know table size in library.Maybe you know how check table size.

[Kurt_Bremser]

I already answered this. For more detailed information, you MUST ask a more clear and detailed question. Terse one-liners don't cut it.

[BrunoMueller]

As already suggested you can use Proc SQL together with a dictionary table to get back this information.

See this code for an example. Beside the filesize some additional columns are shown, see Accessing SAS Information By Using DICTIONARY Tables for more details. It also shows an example for using the the SIZEKMG format.

%let libref = sashelp;

proc sql;
  create table tableSizes as
  select
    libname, memname, memtype, memlabel, nobs, nlobs, nvar, num_character, num_numeric, 
    filesize, filesize as filesizekmg format=sizekmg16.1
  from
    dictionary.tables
  where
    libname = "%upcase(&libref)"
  order by
    filesize desc
  ;
quit;