I am attempting to import an Excel file into SAS using EG3. I am able to import the file without any trouble until it comes to a mixed variable column. By mixed, I mean the possible values may be completely numeric or it may be alpha-numeric. EG3 makes this variable a text variable and drops anything without at least one alpha character. I have attempted adjusting the informats in EG3 with no success. I have also adjusted the column formats in EXcel. Right now, my only solution is to open Excel and copy the column directly onto the SAS datafile. SAS reads the numbers correctly as text when I paste the column.
Can someone please tell me what I am missing to get the data read into EG3 correctly?