We receive a file from external source system. We read the external file (ebcdic) with a layout and create SAS datasets.
Some times, the file layout is getting changed by the source system which was not trapped by the SAS program. Our SAS program ran fine (with invalid data errors in the log file). Later we came to know about the layout change and when we printed few impacted variables, they were populated with junk values.
Can anyone suggest me a best way to identify if there are junk values in the input file? Again we cannot check each and every variable for valid numeric or character as there are 1000s of variables in the input file.
I cannot afford to abend the program if _ERROR_=1 also.
You can use any one of the CHARACTER type call functions to check your SAS variable values, as needed. And based on the variable test results, optionally take action, such as sending an EMAIL with a summary report or some type of evidence revealed.