proc import using "mixed" option

[GreggB]

Can you use the mixed option when importing a tab delimited file?  I'm getting an error.

proc

import datafile='G:\Departments\Research\PowerSchool\Exports\1112\student08102011.text' out=stud dbms

=dlm replace;

delimiter=

'09'x

;

getnames=yes;

mixed=yes;

run

;

[art297]

Gregg,

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.

Art