Problem Note 65715: Unexpected results can occur because the SYSCC automatic macro variable does not reset to zero within SAS® Data Integration Studio job code
 |  |  |  |  |
The SYSCC automatic macro variable retains a nonzero return code value from a prior execution of a SAS Data Integration Studio job. Unexpected results can occur in a subsequent execution of the job, even if the cause of the nonzero return code is addressed, because the nonzero return code is not reset.
The workaround for this issue is to insert the following line of code under Job Properties within the Precode section on the Precode and Postcode tab:
%let SYSCC=0;
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Windows 7 Professional x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
| Windows 7 Enterprise x64 | 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 | ||
| Microsoft Windows Server 2012 R2 Std | 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 Datacenter | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2008 for x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 10 | 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 8.1 Pro 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 Enterprise 32-bit | 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 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft® Windows® for 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#65715
A nonzero return code from a prior execution of a SAS Data Integration Studio job is not cleared from the SYSCC automatic macro variable when you run the job a second time from within the client. This action generates unexpected results.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-03-30 16:03:08 |
| Date Created: | 2020-03-20 09:27:42 |