Problem Note 65295: The order of columns is not maintained when you select columns for output in the Business Rules transformation
 |  |  |  |  |
In SAS® Data Integration Studio, the columns that you select to include in the target table in a Business Rules transformation appear in the Selected columns area in a random order. The column order for the target table should match the order of the columns as you select them in the Available columns area.
The following image demonstrates the incorrect behavior:
There is no workaround other than to manually reorder the output columns in a step after the Business Rules transformation is completed.
Click the Hot Fix tab in this note to access the hot fix for this issue.
The hot fix is for SAS® Data Integration Studio 4.904.
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® for x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
| Microsoft Windows 8 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 10 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2008 R2 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Std | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Std | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Windows 7 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Windows 7 Professional x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
A fix for this issue for Data Integration Studio 4.904 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8Y.html#65295| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-05-06 09:01:07 |
| Date Created: | 2020-01-03 10:38:51 |