Problem Note 70244: Trying to convert a numeric variable to a character variable with the FEDSQL procedure might result in a blank value
 |  |  |  |  |
Trying to convert a numeric variable or value to a character variable using the CAST function with the FEDSQL procedure might result in a blank value. This issue might occur when the following is true:
- You run SAS® Viya® 3.5 or earlier.
- You access a database and there is something in the query that prevents the conversion from being pushed to the database for processing. Instead, the processing is done in SAS® Cloud Analytic Services (CAS), or you access a CAS table.
- You cast to character with a length that is greater than 32.
- The numeric variable that you are trying to convert is a double or float and is not an integer data type.
The only workaround for this issue is to upgrade to the SAS® Viya® Platform.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
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 | 3.5 | Viya 3.5 | ||
| Linux for x64 | 3.5 | Viya 3.5 | ||||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-09-21 16:06:24 |
| Date Created: | 2023-07-06 13:48:38 |