![]() | ![]() | ![]() |
In releases of SAS prior to SAS 9, the maximum number of variables in a single SAS data set under all operating systems is 32,767, with the exception of Tru64 Unix. The limitations for Tru64 Unix are the same for all releases of SAS (see the limitations under SAS 9 below).
Other than the following limitations that apply to Windows operating systems a SAS data set can be as large as the operating system will allow:
Beginning in SAS 9, the maximum number of variables allowed is no longer 32,767. For either Windows or Unix platforms the maximum number of variables is limited by the first encountered limitation:
You can define a data set with an observation length of up to 2GB on a 32-bit platform and approximately 2*46 on a 64-bit platform.
Assuming a single-byte character set, and that you use the maximum 352 bytes possible for name, label, and so on for each variable, you can have a maximum of about 4,050,000 variables. If the names, labels, and format names are shorter, you can have more than 200,000,000. There is a maximum of 1GB to store all the variable names and other metadata (data set label, compression name, etc).
Assuming the above limits are not exceeded, the maximum possible number of variables on either Windows or Unix is 412,977,617 on 32-bit hosts and 2GB on 64-bit hosts. For z/OS platform the maximum number of variables is primarily limited by the maximum size of a single observation (16MB or 1,677,7216 bytes).
For z/OS the maximum number of observations is 2**31-1 = 2147483647 (2G).
The maximum size of a SAS data set in a Direct Access Bound Library is limited by the maximum size of the library, which is about 2986G bytes on 3390 volumes.
The maximum size of a SAS data set in a USS Library is limited by the maximum number of pages, which is 2**31-1 = 2147483647 = about 2GB. Assuming a fairly typical page size of 32K bytes, the maximum size of the data set would then be about 2**46 by bytes = 64TB. However, larger data sets could be created by specifying a BUFSIZE value larger than 32KB.
Data sets created with SAS 9 on any operating system that contain more
than 32,767 variables are not accessible by prior versions.
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | Base SAS | Microsoft Windows XP Professional | 8.2 TS2M0 | |
| Microsoft Windows NT Workstation | 8 TS M0 | |||
| Microsoft Windows 95/98 | 8 TS M0 | |||
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 8.2 TS2M0 | |||
| Microsoft Windows 2000 Server | 8 TS M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 8.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 8.2 TS2M0 | |||
| Microsoft Windows 2000 Professional | 8 TS M0 | |||
| Microsoft Windows 2000 Advanced Server | 8 TS M0 | |||
| Microsoft Windows 2000 Datacenter Server | 8 TS M0 | |||
| 64-bit Enabled Solaris | 8.2 TS2M0 | |||
| Solaris | 8.2 TS2M0 | |||
| OpenVMS VAX | 8.2 TS2M0 | |||
| IRIX | 8.2 TS2M0 | |||
| z/OS | 8.2 TS2M0 | |||
| Linux | 8.2 TS2M0 | |||
| OS/2 | 8.2 TS2M0 | |||
| ABI+ for Intel Architecture | 8.2 TS2M0 | |||
| CMS | 8.2 TS2M0 | |||
| HP-UX | 8.2 TS2M0 | |||
| 64-bit Enabled HP-UX | 8.2 TS2M0 | |||
| OpenVMS Alpha | 8.2 TS2M0 | |||
| 64-bit Enabled AIX | 8.2 TS2M0 | |||
| Tru64 UNIX | 8.2 TS2M0 | |||
| AIX | 8.2 TS2M0 |
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> SAS Data Sets/Tables Common Programming Tasks |
| Date Modified: | 2008-06-12 08:53:37 |
| Date Created: | 2002-08-08 13:48:49 |



