Problem Note 16554: SAS 9.1 htmSQL on LINUX returns missing date values as "*BadDate", missing numeric values as "nan"
 |  |  |  |  |
The SAS® 9.1.3 htmSQL executable running on LINUX incorrectly returns the string "*BadDate" for missing date values. The string "nan" is incorrectly returned for missing numeric values. The value for both missing data and numeric value should be a represented as a '.'.
To circumvent this result, use the SAS Version 8.2 htmSQL executable.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/IntrNet | Linux | 9.1 TS1M3 | 9.1 TS1M3 SP4 |
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#016554A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#016554| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> SQL |
| Date Modified: | 2006-04-26 09:19:44 |
| Date Created: | 2005-11-18 16:25:50 |