Problem Note 60775: Transcoding errors occur if you apply a special string with URLDECODE function from SAS® Enterprise Guide® to a local SAS® server with UTF-8 encoding
 |  |  |  |
When you submit a special string using the URLDECODE function from SAS Enterprise Guide to a local SAS server with UTF-8 encoding, you might see this message:
The error occurs because of the use of an invalid string such as %AD and the URLDECODE function, as shown in this example:
data a;
x1=urldecode('why%AD');
put x1;
run;
In this first example, we see that %AD used with the URLDECODE function leads to the transcoding error because it is not a valid UTF-8 string.
For more information, see this URLDECODE Function page of the SAS® 9.4 Functions and CALL Routines: Reference manual.
Workarounds
Use one of the following workarounds.
Apply a Valid String
If you run a valid string from SAS Enterprise Guide with a local UTF-8 server, you might not see the error shown above.
For example, if you use this string:
data a;
x1=urldecode('why%3D');
put x1;
run;
You get the output results shown below because %3D is a valid string with UTF-8 encoding, which shows as the = string.
Remove the URLDECODE Function
When you use this string:
data a;
x1='abc%ADdefg';
put x1;
run;
You get results similar to the following:
Use SAS English WLATIN1 Encoding on a Local SAS Server
- Find the file sasv9.cfg under this directory: C:\Program Files\SASHome\SASFoundation\9.4
- Open the file with Notepad and change the contents as shown below:
-config "C:\Program Files\SASHome\SASFoundation\9.4\nls\en\sasv9.cfg"
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4_M4 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 8 Enterprise x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 8 Pro 32-bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 8 Pro x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows 10 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 R2 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.4_M4 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 Std | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Enterprise 32 bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Enterprise x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Home Premium 32 bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Home Premium x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Professional 32 bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Professional x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Ultimate 32 bit | 9.4_M4 | 9.4 TS1M4 | ||||
| Windows 7 Ultimate x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| 64-bit Enabled AIX | 9.4_M4 | 9.4 TS1M4 | ||||
| 64-bit Enabled Solaris | 9.4_M4 | 9.4 TS1M4 | ||||
| HP-UX IPF | 9.4_M4 | 9.4 TS1M4 | ||||
| Linux for x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| z/OS 64-bit | 9.4_M4 | 9.4 TS1M4 | ||||
| z/OS | 9.4_M4 | 9.4 TS1M4 | ||||
| Solaris for x64 | 9.4_M4 | 9.4 TS1M4 | ||||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-10-09 15:53:32 |
| Date Created: | 2017-07-18 16:41:48 |