topic Re: Good afternoon I have a library and there are tables, how can I find out the table size in sas g in SAS Enterprise Guide

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

Satora_In — Wed, 04 Oct 2023 19:58:26 GMT

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

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

Kurt_Bremser — Wed, 04 Oct 2023 20:44:48 GMT

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.

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

Satora_In — Thu, 05 Oct 2023 05:19:41 GMT

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

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

Kurt_Bremser — Thu, 05 Oct 2023 05:46:56 GMT

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

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

Satora_In — Thu, 05 Oct 2023 08:25:21 GMT

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

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

BrunoMueller — Thu, 05 Oct 2023 08:33:46 GMT

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;

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

Kurt_Bremser — Thu, 05 Oct 2023 08:34:25 GMT

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