I have a program that compiles results from other individual programs (that verify that tables contain valid data - source to target). Occasionally, something happens where an individual program that creates the results table abends or creates an empty dataset. When this happens, the result table ends up with columns that have a data type of numeric rather than char (normal). When this happens, the program that compiles all the results chokes because the data types of table columns (numeric) of empty datasets don’t agree with the ‘good’ ones (char). I can run proc datasets to get the column data types of the results datasets and go through them visually to determine which datasets are bad but the number of datasets can exceed 100 so this is a labor intensive effort. My question is: Is there a way (progamatically) to identify result datasets where the data type of a particular column is numeric?
... View more