Help using Base SAS procedures

proc import using "mixed" option

Reply
Super Contributor
Posts: 268

proc import using "mixed" option

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

;

PROC Star
Posts: 7,363

Re: proc import using "mixed" option

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

Ask a Question
Discussion stats
  • 1 reply
  • 348 views
  • 0 likes
  • 2 in conversation