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,438

Re: SAS Data Set's size

Posted in reply to AnandSahu

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

Posted in reply to AnandSahu

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: 118

Re: SAS Data Set's size

Posted in reply to AnandSahu

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

Posted in reply to umashankersaini

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

Frequent Contributor
Posts: 118

Re: SAS Data Set's size

Posted in reply to AnandSahu

Hi Andy,

Thanks for your comment...

Warm welcome...

Regards

Uma Shanker Saini

www.sascertguru.com

Super User
Posts: 10,044

Re: SAS Data Set's size

Posted in reply to AnandSahu

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: 10,044

Re: SAS Data Set's size

Posted in reply to AnandSahu

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
  • 396 views
  • 5 likes
  • 5 in conversation