Please, can someone help me understand this error?
How can I further automate the data loading in SAS Viya?
The source of the error appears to be clear: using an incorrect data type for some purpose.
Solution: make sure the data is the correct type.
Almost any sort of "automated" data load where the properties of variables are not controlled may eventually lead to such a problem. A common approach it to control how the data is read into SAS for use to ensure appropriate data types and values. Without knowing a LOT more about your data sources that sort of generality is about all that can be provided.
Warning: some file types seem to lend themselves to more data inconsistency issues than others. Spreadsheets do not generally provide any sort of column restrictions so you can end up with some character values mixed in with what should be a numeric column or vice versa. Not much in the way of automation is possible with this if the source is poor to begin with.
This SAS note explains the most likely cause. Only DOUBLE is supported for numeric variables
.
https://support.sas.com/kb/64/945.html
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.