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.
Could your NETZ2 library point to a Netezza database - SAS cannot provide table size details for external databases.
Is "Netz2" aka "SASDATA" a base/v9 library?
Could your NETZ2 library point to a Netezza database - SAS cannot provide table size details for external databases.
Or if you were using SPDServer for SAS, you can't get table size either .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.