SAS Data Integration Studio might provide the most effective way to generalise without having to write lots of code.
PROC IMPORT (not available on z/OS) has a DBMS= parameter allowing values like DLM, CSV and EXCEL.
A better alternative (imho) than PROC IMPORT, are the libname engines (also known as: SAS/Access data library engines).
For text including CSV, where we can recognise the column definition by some metadata or a name in a column header, I would still not use PROC IMPORT, because you will know so much more about the data and its purpose than PROC IMPORT can derive.
PeterC