SUPPORT / SAMPLES & SAS NOTES
Problem Note 20525: A checked out job containing an SQL join transformation with ORDER BY/GROUP BY column(s) loses the mappings for those columns
 |  |  |  |  |
In SAS® Data Integration Studio 3.4, if your job uses the new SQL join transformation in which a GROUP BY or ORDER BY clause has been specified, and you do not check out the table(s) to which those columns belong the column mappings will be missing in the generated code.
To prevent this from happening, you must check out any table that is associated with the specified columns on the ORDER BY or GROUP BY clause.
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft Windows Server 2003 Enterprise Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows XP Professional | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft® Windows® for x64 | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||