Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
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 | ||||