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?
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
- Tom Abernathy