Is this type (eg.1,396,123.05) are mixed datatype? All the variable in this type are converted into character.
Actually, I need to import a set of CSV files (around 50 files), which have different combination of variables (around 20 combinations).It is very time consuming to use INPUT function to input files one by one.
Not mixed, but it's formatted numerical data, that PROC IMPORT will interpret as CHAR. Unfortunately PROC IMPORT does nor support INFORMAT, and I'm not aware of any generic way to set a INFORMAT as default. If you have a name standard for columns with these formatted values, you may do some macro coding.
The alternative is when using EG, you can specify informats during import (this beacuse EG does not use PROC IMPORT). But this will be per file basis...