Date:         Fri, 9 Jul 2010 16:49:41 -0400
Reply-To:     Tom Abernathy <tom.abernathy@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tom Abernathy <tom.abernathy@GMAIL.COM>
Subject:      Re: Can one import delimited file directly with proc sql?

Art -
  I would use the macro that my old fried Tom Hoffman wrote to read a text
file.  It can output the file to an array of macro variables or just as the
output of the macro call (like a function).

  Then I could code:

  proc sql ;
     create table new as
        select %fread(mydata.file,mode=3) as mynumber
     ;
  quit;

- Tom Abernathy