Problem Note 50641: Errors occur when you execute a job in which the parameter values contain text values that end in a percent sign (%)
 |  |  |  |
If Job or Transformation parameters contain text values that end in a percent sign (%), the percent sign is not properly masked in the code that is generated. This can result in errors when you execute a job.
If the parameter values for a Loop transformation contain the text values that end in a percent sign, you might receive the following error message:
ERROR: Expected close parenthesis after macro function invocation not found.
To work around the errors that are received in a Loop transformation, modify the code that is generated by SAS® Data Integration Studio.
- Open the job in the job editor window. Right-click the Loop transformation and select Properties.
- Click the Code tab. Change the code generation mode to user written body.
- Locate the following line in the code:
value='%str('||trim(value)||')';
- Change the %STR function to %NRSTR:
value='%nrstr('||trim(value)||')';
- Save your job.
Operating System and Release Information
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.Product Family Product System Product Release SAS Release Reported Fixed* Reported Fixed* SAS System SAS Data Integration Studio Windows Vista for x64 4.21_M1 9.2 TS2M3 Windows Vista 4.21_M1 9.2 TS2M3 Windows 7 Ultimate x64 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Windows 7 Ultimate 32 bit 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Windows 7 Professional x64 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Windows 7 Professional 32 bit 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Windows 7 Home Premium x64 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Windows 7 Home Premium 32 bit 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Windows 7 Enterprise x64 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Windows 7 Enterprise 32 bit 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Microsoft Windows XP Professional 4.21_M1 9.2 TS2M3 Microsoft Windows Server 2008 for x64 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Microsoft® Windows® for x64 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Microsoft Windows Server 2003 Datacenter Edition 4.21_M1 9.2 TS2M3 Microsoft Windows Server 2003 Enterprise Edition 4.21_M1 9.2 TS2M3 Microsoft Windows Server 2003 Standard Edition 4.21_M1 9.2 TS2M3 Microsoft Windows Server 2003 for x64 4.21_M1 9.2 TS2M3 Microsoft Windows Server 2008 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1 Microsoft Windows Server 2008 R2 4.21_M1 4.8 9.2 TS2M3 9.4 TS1M1
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-09-20 15:28:47 |
| Date Created: | 2013-08-05 15:23:16 |