topic Re: How to read the size of a file witout using proc contents or exporting file? in SAS Programming

How to read the size of a file witout using proc contents or exporting file?

Phil_NZ — Thu, 11 Mar 2021 09:55:16 GMT

Hi everyone,

After running some codes, I have some datasets as below:

I am wondering if there is any way to see the size of a dataset (e.g: pctzero) on that list without using proc contents and exporting the dataset?

Warm regards.

Re: How to read the size of a file witout using proc contents or exporting file?

Kurt_Bremser — Thu, 11 Mar 2021 10:27:10 GMT

See this example code for SASHELP.CLASS:

proc sql;
select filesize from dictionary.tables
where libname = "SASHELP" and memname = "CLASS";
quit;

Re: How to read the size of a file witout using proc contents or exporting file?

ballardw — Thu, 11 Mar 2021 12:53:08 GMT

Which definition of "size" are you wanting? Bytes, Kbytes,number of records, something else?

If you right click on the data set icon do you get a context menu? Does that show a "Details" option?

Re: How to read the size of a file witout using proc contents or exporting file?

Phil_NZ — Thu, 11 Mar 2021 20:38:47 GMT

Hi @ballardw

There is no details option then.

And what I want is how many GB, or MB the file is.

Warm regards.

Re: How to read the size of a file witout using proc contents or exporting file?

Phil_NZ — Thu, 11 Mar 2021 20:44:52 GMT

Hi @Kurt_Bremser

Thank you for your suggestion.

I run it and I got the result as below for sashelp. class, could you please tell me how to read it, is it under KB or bytes, simplistically speaking, how many mb it is ?

I run the code

proc sql;
select * from dictionary.dictionaries
;
quit;

To get the information but they did not show it is KB or bytes or else

Warm regards.

Re: How to read the size of a file witout using proc contents or exporting file?

Kurt_Bremser — Thu, 11 Mar 2021 20:54:13 GMT

filesize is in bytes. CLASS is so small that it is stored in a single dataset page, which is 128K.