SUPPORT / SAMPLES & SAS NOTES
Problem Note 35779: The LENGTH= column modifier is handled incorrectly when you use PROC SQL to create character columns in SAS® Scalable Performance Data Server® tables
 |  |  |  |  |
The LENGTH= column modifier is not handled correctly when you use the SQL procedure to create character columns in SAS Scalable Performance Data Server tables.
If you create a SAS Scalable Performance Data Server table using a LIBNAME connection and you add the LENGTH= column modifier for a character, the implicit pass-through facility does not handle the new length correctly. The column is not properly padded with blanks.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.1 TS1M3 | 9.2 TS2M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Windows Vista | 9.1 TS1M3 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS2M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS2M0 | ||
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS2M0 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS2M0 | ||