Hi

a few columns in Excel include both char and numeric, eg.
variable date includes 10022009 (most of them in this format) and
10/02/2009 and 10.02.2009
variable language includes English, Japanese, and 14, 19 (their code)

list are very long, and I have a few Excel file to import into SAS.

when I use proc import, it can't input these variables properly. May I
ask how can I define them as character in the proc import process?
then, I can handle them in SAS (as I have a lot of variables, using
input variable name takes too much time)

Thank you

Dear Arthur,

Thank you very much

Mixed=yes; looks not available in my SAS 9.

not sure any other solutions?

Thanks
Zespri