Problem Note 63014: Using PROC CONTENTS or SAS® Explorer to list or view the column attributes of a data set might generate exception errors
 |  |  |  |  |
Your SAS® log might display exception errors when you run the CONTENTS procedure on a data set. An example of the code that can cause this problem is shown here:
libname sampsio list;
proc contents data=sampsio.allsites;
run;
proc contents data=sampsio.allsites;
run;
The same data set is printed without errors. However, an error that is similar to the following appears in the SAS log:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [CONTENTS]
ERROR: Write Access Violation CONTENTS
Exception occurred at (00000002)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
00007FFED60E89E1 000000BB670F0C18 sashost:Main+0x9E831
00007FFED61010D6 000000BB670F0E50 sashost:Main+0xB6F26
00007FFED60EB642 000000BB670F0EE0 sashost:Main+0xA1492
00007FFED60EAA0C 000000BB670F0FA0 sashost:Main+0xA085C
00007FFEC777E1A5 000000BB670F0FA8 sase7opn:tkvercn1+0xD165
00007FFEC77F5C7F 000000BB670F10B8 sasyoio:tkvercn1+0x34C3F
00007FFEE05F23B4 000000BB670F1108 sasqutil:tkvercn1+0x51374
00007FFEE05CC0E7 000000BB670F9AA0 sasqutil:tkvercn1+0x2B0A7
00007FFEE05ACE49 000000BB670FF280 sasqutil:tkvercn1+0xBE09
00007FFEE05BFAFA 000000BB670FF720 sasqutil:tkvercn1+0x1EABA
00007FFEE4B30150 000000BB670FF728 sasxshel:tkvercn1+0x4F110
00007FFEE05F9996 000000BB670FF840 sasqutil:tkvercn1+0x58956
00007FFEE05A14A1 000000BB670FF930 sasqutil:tkvercn1+0x461
00007FFED605ED88 000000BB670FFBA0 sashost:Main+0x14BD8
00007FFED6064E4D 000000BB670FFBD0 sashost:Main+0x1AC9D
00007FFF22871FE4 000000BB670FFBD8 KERNEL32:BaseThreadInitThunk+0x14
00007FFF234FCB31 000000BB670FFC08 ntdll:RtlUserThreadStart+0x21
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.67 seconds
cpu time 0.29 seconds
Please contact technical support and provide them with the following traceback information:
The SAS task name is [CONTENTS]
ERROR: Write Access Violation CONTENTS
Exception occurred at (00000002)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
00007FFED60E89E1 000000BB670F0C18 sashost:Main+0x9E831
00007FFED61010D6 000000BB670F0E50 sashost:Main+0xB6F26
00007FFED60EB642 000000BB670F0EE0 sashost:Main+0xA1492
00007FFED60EAA0C 000000BB670F0FA0 sashost:Main+0xA085C
00007FFEC777E1A5 000000BB670F0FA8 sase7opn:tkvercn1+0xD165
00007FFEC77F5C7F 000000BB670F10B8 sasyoio:tkvercn1+0x34C3F
00007FFEE05F23B4 000000BB670F1108 sasqutil:tkvercn1+0x51374
00007FFEE05CC0E7 000000BB670F9AA0 sasqutil:tkvercn1+0x2B0A7
00007FFEE05ACE49 000000BB670FF280 sasqutil:tkvercn1+0xBE09
00007FFEE05BFAFA 000000BB670FF720 sasqutil:tkvercn1+0x1EABA
00007FFEE4B30150 000000BB670FF728 sasxshel:tkvercn1+0x4F110
00007FFEE05F9996 000000BB670FF840 sasqutil:tkvercn1+0x58956
00007FFEE05A14A1 000000BB670FF930 sasqutil:tkvercn1+0x461
00007FFED605ED88 000000BB670FFBA0 sashost:Main+0x14BD8
00007FFED6064E4D 000000BB670FFBD0 sashost:Main+0x1AC9D
00007FFF22871FE4 000000BB670FFBD8 KERNEL32:BaseThreadInitThunk+0x14
00007FFF234FCB31 000000BB670FFC08 ntdll:RtlUserThreadStart+0x21
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.67 seconds
cpu time 0.29 seconds
In SAS Explorer, if you right-click the data set and select View Columns, you might see similar errors in the log. In that scenario, the error indicates that the SAS task name is “[Variable Listing]” rather than “[CONTENTS]” or “[Submit].”
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 9.4_M5 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 9.4_M5 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4_M5 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Linux for x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Solaris for x64 | 9.4_M5 | 9.4_M6 | 9.4 TS1M5 | 9.4 TS1M6 | ||
A fix for this issue for Base SAS User Interface 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D4S.html#63014
The SAS log might display errors when you run PROC CONTENTS on a data set although the same data set prints without errors. If you right-click the data set in the SAS Explorer window to view column attributes, the log reports similar errors.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-10-11 13:42:50 |
| Date Created: | 2018-10-01 13:34:11 |