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.
See this example code for SASHELP.CLASS:
proc sql;
select filesize from dictionary.tables
where libname = "SASHELP" and memname = "CLASS";
quit;
See this example code for SASHELP.CLASS:
proc sql;
select filesize from dictionary.tables
where libname = "SASHELP" and memname = "CLASS";
quit;
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.
filesize is in bytes. CLASS is so small that it is stored in a single dataset page, which is 128K.
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?
Hi @ballardw
There is no details option then.
And what I want is how many GB, or MB the file is.
Warm regards.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.