Problem Note 16629: SASHELP.VTABLE and DICTIONARY.TABLES reports FILESIZE 1 greater than it
should be
SASHELP.VTABLE is a view of DICTIONARY.TABLES. The FILESIZE column is
being calculated as (NPAGE+1) * BUFSIZE. When comparing to a PROC
CONTENTS output from directory based systems which report FILESIZE, the
value presented is different.
For SAS libraries on mainframe, the FILESIZE calculation should be NPAGE
* BUFSIZE. However, on the directory based systems there is more
involved with calcualting the size of the member. In the member is
directory space information along with the contents associated with the
member. What is reported from the PROC CONTENTS is accurate for actual
used space. What is reported by DICTIONARY.TABLES for size of file is
reported greater than the actual, by as much as one (1) BUFSIZE value.
The BUFSIZE column of DICTIONARY.TABLES maps to Data Set Page Size from
the PROC CONTENTS output.
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows XP Professional | 9.1 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | |
| Microsoft Windows 2000 Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
| 64-bit Enabled Solaris | 9.1 TS1M0 | |
| Linux | 9.1 TS1M0 | |
| z/OS | 9.1 TS1M0 | |
| 64-bit Enabled AIX | 9.1 TS1M0 | |
| OpenVMS Alpha | 9.1 TS1M0 | |
| HP-UX IPF | 9.1 TS1M0 | |
| 64-bit Enabled HP-UX | 9.1 TS1M0 | |
| Tru64 UNIX | 9.1 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | low |
| Topic: | SAS Reference ==> Procedures ==> SQL
SAS Reference ==> SQL
|
| Date Modified: | 2006-01-10 10:38:43 |
| Date Created: | 2005-12-05 12:13:40 |
