Problem Note 64427: Particular date informats that use periods as delimiters are not read correctly during a SAS® Cloud Analytic Services session
 |  |  |  |  |
During a CAS session, DDMMYYw., MMDDYYw., YYMMDDw., and DATEw. informats that use period-separated values are not read correctly. For example, the following code should generate the date value of 01JAN2019:
data _null_ / sessref=mysession ;
date = Input('01.01.2019', ddmmyy10.) ;
format date date9. ;
put date ;
run ;
date = Input('01.01.2019', ddmmyy10.) ;
format date date9. ;
put date ;
run ;
Instead, the SAS log generates the following notes about missing values:
NOTE: Running DATA step in Cloud Analytic Services.
NOTE: Invalid argument to function INPUT at line 75 column 14.
.
date=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 75:14
NOTE: Duplicate messages output by DATA step:
NOTE: Invalid argument to function INPUT at line 75 column 14. (occurred 24 times)
. (occurred 24 times)
date=. _ERROR_=1 _N_=1 (occurred 24 times)
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
missing values. (occurred 24 times)
Each place is given by: (Number of times) at (Line):(Column). (occurred 24 times)
1 at 75:14 (occurred 24 times)
NOTE: Invalid argument to function INPUT at line 75 column 14.
.
date=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 75:14
NOTE: Duplicate messages output by DATA step:
NOTE: Invalid argument to function INPUT at line 75 column 14. (occurred 24 times)
. (occurred 24 times)
date=. _ERROR_=1 _N_=1 (occurred 24 times)
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
missing values. (occurred 24 times)
Each place is given by: (Number of times) at (Line):(Column). (occurred 24 times)
1 at 75:14 (occurred 24 times)
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 | V.03.00_M2 | Viya | ||
| Linux for x64 | V.03.00_M2 | Viya | ||||
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates
When you use a DDMMYYw., MMDDYYw., YYMMDDw., or DATEw. informat during a CAS session, the value is not read correctly when the delimiter is a period. In the SAS® log, you see notes about invalid arguments and missing values.
| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> Informats ==> Date and Time ==> DATE SAS Reference ==> Informats ==> Date and Time ==> DDMMYY SAS Reference ==> Informats ==> Date and Time ==> MMDDYY SAS Reference ==> Informats ==> Date and Time ==> YYMMDD |
| Date Modified: | 2019-08-22 08:39:36 |
| Date Created: | 2019-07-02 10:00:00 |