Identifying Files Size

sheren_deep1 — Tue, 23 Apr 2019 05:39:38 GMT

Hi,

I am currently using SAS EG and connected to a SAS Server. I would like to check the files size that are sitting on a library called (NETZ2). I used the following codes to check the file size.

proc sql;
 select memname, filesize format=sizekmg10.1
   from dictionary.tables
   where libname='SASDATA' and memtype='DATA';
quit;

However, the result shows 0.00KB size of file in the respective column as shown below.

Meanwhile, the dataset (for example: FACT_BPPD_POPULATION) actually contained data for roughly 75 million records. However, when i try to check file size for datasets that are sitting in other libraries with the proc sql above codes i could get the exact file size for those datasets in the other libraries.

Could someone please help me to understand why this is happening? and if there is any other way that i can check the filesize for datasets in this particular library.

Thank You.

Re: Identifying Files Size

andreas_lds — Tue, 23 Apr 2019 06:02:37 GMT

Is "Netz2" aka "SASDATA" a base/v9 library?

Re: Identifying Files Size

SASKiwi — Tue, 23 Apr 2019 07:04:37 GMT

Could your NETZ2 library point to a Netezza database - SAS cannot provide table size details for external databases.

Re: Identifying Files Size

Ksharp — Tue, 23 Apr 2019 12:53:03 GMT

Or if you were using SPDServer for SAS, you can't get table size either .

topic Identifying Files Size in SAS Programming

Identifying Files Size

Re: Identifying Files Size

Re: Identifying Files Size

Re: Identifying Files Size