topic Re: How big data SAS can read and accept in SAS Programming

How big data SAS can read and accept

ksuman — Wed, 10 Jul 2013 09:45:40 GMT

Hi Friends,

Can anyone please tell me how big data SAs can read or import. (Ex:- Gigabyte, or Terra byte).

If anyone can share a link that would be the awesome.

Many thanks

Regards,

Suman K

Re: How big data SAS can read and accept

umashankersaini — Wed, 10 Jul 2013 10:33:47 GMT

Hi,

In most cases, the maximum file size for a SAS data set is 2 gigabytes (GB). However, if you run the SAS System under Windows NT and store
your data on a volume formatted with the Windows NT file system (NTFS), you can
create and store data sets larger than 2GB. For more information about this
feature and its uses, see Using Large Data Sets with Windows NT and NTFS.

for more info : Using SAS Files : Introduction to SAS Files

Regards

Uma Shanker Saini

Re: How big data SAS can read and accept

umashankersaini — Wed, 10 Jul 2013 10:44:00 GMT

Hi,

Here i have talked only about the SAS datasets not about the data.

1. A SAS dataset stored on a drive that is formatted as FAT16 has a file size limit of 2.1GB

2. A SAS dataset stored on a drive that is formatted as FAT32 has a file size limit of 4 GB

3. A SAS dataset stored on a drive that is stored on NTFS formatted has a file size limit of 2 TB.

Re: How big data SAS can read and accept

Doc_Duke — Wed, 10 Jul 2013 16:36:26 GMT

see 36112 - Managing large SAS® data sets that exceed the maximum number of observations

Re: How big data SAS can read and accept

FriedEgg — Wed, 10 Jul 2013 16:44:10 GMT

You are limited more by your hardware than you are by SAS whether it be gigabyte, terabyte, petabyte...

Re: How big data SAS can read and accept

Reeza — Wed, 10 Jul 2013 16:46:26 GMT

Isn't that desktop or server dependent?

Re: How big data SAS can read and accept

AhmedAl_Attar — Wed, 10 Jul 2013 17:11:09 GMT

One other aspect to consider, SAS allows for storing partitioned data files via the use of the SPDE and SPDS, which in turn could allow your SAS table to go beyond the O/S limits!

Example, you can build a SAS table based on multiple partitions where each partition size is 2GB.

So the advice here is not focus solely on the maximum size of a single conventional data set, instead be aware of SAS's full capability.

Hope this helps,

Ahmed