Problem Note 40071: Character columns might be padded with a null value when you join two or more ODBC tables
 |  |  |  |
A character column is padded with an extra null value rather than a blank when you increase the column length in the SELECT statement of a join operation that involves two or more ODBC tables.
Example:
libname mssql odbc dsn=odbcdata user=sasdemo pw=saspw;
proc sql;
create table xx as
select x1.txt LENGTH = 6,
x2.id
from mssql.x1, mssql.x2
where x1.id=x2.id;
quit;
If the .txt variable is shorter than 6 bytes in the ODBC table, the value '00'x is appended to the original string.
There is no solution for this problem. However, the problem is fixed in SAS® 9.2.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Windows Vista | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Windows Vista for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
Character columns might be padded with a null value when you join two or more ODBC data sources AND you increase the column length in the SELECT statement.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> ODBC (Open Database Connectivity) |
| Date Modified: | 2010-07-13 13:07:47 |
| Date Created: | 2010-06-22 05:55:42 |