Problem Note 50703: An incorrect number of rows are returned from the Extract transformation
 |  |  |  |  |
You might receive incorrect data when you use the Extract transformation in SAS® Data Integration Studio. The incorrect number of rows might be returned. The problem occurs under the following conditions:
- You use multiple SAS® views in a PROC SQL join query.
- The same column or columns are defined in multiple views and in the PROC SQL join query.
- The column definitions in the views contain a column alias or column modifier, such as LENGTH, INFORMAT or FORMAT.
- The column is used on the WHERE or HAVING clause.
To work around this problem, modify the SAS Data Integration Studio job to use the SAS data sets or database tables instead of SAS views.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M1 | |||
| Microsoft Windows Server 2008 | 9.3 TS1M1 | |||
| Microsoft Windows Server 2008 R2 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft Windows XP Professional | 9.3 TS1M1 | |||
| Windows 7 Enterprise 32 bit | 9.3 TS1M1 | |||
| Windows 7 Enterprise x64 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M1 | |||
| Windows 7 Home Premium x64 | 9.3 TS1M1 | |||
| Windows 7 Professional 32 bit | 9.3 TS1M1 | |||
| Windows 7 Professional x64 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M1 | |||
| Windows 7 Ultimate x64 | 9.3 TS1M1 | |||
| Windows Vista | 9.3 TS1M1 | |||
| Microsoft® Windows® for x64 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Z64 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| z/OS | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Windows Vista for x64 | 9.3 TS1M1 | |||
| 64-bit Enabled AIX | 9.3 TS1M1 | 9.4 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.3 TS1M1 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 9.3 TS1M1 | 9.4 TS1M0 | ||
| HP-UX IPF | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Linux | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Linux for x64 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Solaris for x64 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.3 TS1M2 | |||
| Microsoft Windows 8 Enterprise x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Pro 32-bit | 9.3 TS1M2 | |||
| Microsoft Windows 8 Pro x64 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2012 Datacenter | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2012 Std | 9.3 TS1M2 | 9.4 TS1M0 | ||
A fix for this issue for Base SAS 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F98.html#50703A fix for this issue for Base SAS 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I22.html#50703| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2014-08-20 16:53:34 |
| Date Created: | 2013-08-09 09:30:45 |