Identifying Files Size

[sheren_deep1]

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. 

[andreas_lds]

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

[SASKiwi · Accepted solution]

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

[Ksharp]

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