topic Re: proc import using "mixed" option in SAS Procedures

proc import using "mixed" option

GreggB — Wed, 10 Aug 2011 17:53:18 GMT

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 — Wed, 10 Aug 2011 18:03:37 GMT

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.

The article contains step-by-step instructions for accomplishing such a task. That will also get rid of the notes.

Art