08-10-2011 01:53 PM
Can you use the mixed option when importing a tab delimited file? I'm getting an error.
import datafile='G:\Departments\Research\PowerSchool\Exports\1112\student08102011.text' out=stud dbms
08-10-2011 02:03 PM
No. An alternative is to grab the code that proc import creates and simply modify it so that you are reading the field(s) as characters.
A nice artice on that topic can be found at: http://www2.sas.com/proceedings/sugi30/038-30.pdf
The article contains step-by-step instructions for accomplishing such a task. That will also get rid of the notes.