Problem Note 44688: An INPUT() function used in PROC SQL might return incorrect results
 |  |  |  |  |
Character functions used inside the INPUT() function might cause incorrect results to be returned by PROC SQL
The character functions SCAN(), SUBSTR(), and SUBPAD() return strings that can vary in length. If you embed these character functions in the INPUT() function, incorrect results might be returned.
The incorrect results occur when the INPUT() function receives strings that vary in length and the current value is shorter than the previous value. Any previous values that are not overwritten by the current shorter values are left in the buffer and are included with the results of the shorter string.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.2 TS1M0 | 9.3 TS1M1 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Windows Vista | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Windows Vista for x64 | 9.2 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled AIX | 9.2 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.3 TS1M1 | ||
| HP-UX IPF | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Linux | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Linux for x64 | 9.2 TS1M0 | 9.3 TS1M1 | ||
| OpenVMS on HP Integrity | 9.2 TS1M0 | 9.3 TS1M1 | ||
| Solaris for x64 | 9.2 TS1M0 | 9.3 TS1M1 | ||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#44688| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-10-20 12:42:56 |
| Date Created: | 2011-10-19 13:39:38 |