@Jagadishkatam already mentioned the reason for the error. This error is quite common when using Excel as data-source and the guessing procedure proc import.
You have two options:
move the data to csv and import those files with a data-step.
Check which columns have same name but different types and length, add data-steps fixing wrong type and length.
... View more