SAS Data Set's size

Reply
Frequent Contributor
Posts: 81

SAS Data Set's size

Hi All,

Can anybody update me, how can I calculate the size of a SAS Data Set.

-anand

Super User
Posts: 5,256

Re: SAS Data Set's size

In SASHELP.VTABLE there is a column filesize, which is calculated by (NPAGE+1) * BUFSIZE. This is the easiest way. But I don't think this will take any index size into count.

If you are on a directory based system, you could easily query for the actual file sizes in the OS, including indexes.

In case of SPDE/SPD Server, it's a bit trickier, since they can spread files in multiple file systems.

SAS(R) 9.4 Language Reference: Concepts, Second Edition

25289 - Determine the Size of SAS Data Sets on PC, UNIX, VAX and Linux Servers

Data never sleeps
Super Contributor
Posts: 394

Re: SAS Data Set's size

Calculating Data Set Size

I used Google to search using these keywords: size of a sas data set site:support.sas.com

Frequent Contributor
Posts: 114

Re: SAS Data Set's size

Hi Anand,

We always look for SAS data set size to optimize the system to set some SAS system options.

For more information, kindly refer to :  SAS Certification prep and basic understanding: To calculate SAS Data set's Size


Regards

Uma Shanker Saini

www.sascertguru.com

Frequent Contributor
Posts: 81

Re: SAS Data Set's size

Thanx Uma.....It helped me a lot :-)

Frequent Contributor
Posts: 114

Re: SAS Data Set's size

Hi Andy,

Thanks for your comment...

Warm welcome...

Regards

Uma Shanker Saini

www.sascertguru.com

Super User
Posts: 9,676

Re: SAS Data Set's size

If your SAS is SPDS. try OS command.

I wrote a paper before, but SGF not accepted it . Smiley Sad:smileycry:

Dropbox - Did you know how big your library is .pdf

Xia Keshan

Frequent Contributor
Posts: 81

Re: SAS Data Set's size

Ksharp

I don't use SPDS so it didn't help me :-(

Super User
Posts: 9,676

Re: SAS Data Set's size

Assuming your engine can identity the size of dataset.

proc contents data=sashelp.class details;run;

Xia Keshan

Ask a Question
Discussion stats
  • 8 replies
  • 383 views
  • 5 likes
  • 5 in conversation