Date: Mon, 23 Jul 2001 15:36:34 -0500
Reply-To: Rob Rohrbough <Rob@ROHRBOUGH-SYSTEMS.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Rob Rohrbough <Rob@ROHRBOUGH-SYSTEMS.COM>
Subject: Re: Data Input Packages for SAS?
Content-Type: text/plain; charset="iso-8859-1"
SAS does provide an "Import Wizard" which handles most delimited (comma,
tab, etc.), I believe, even without SAS/ACCESS. SAS Access, as you mention,
does support a wide variety of formatted files (e.g., from Excel to Oracle -
depending on your license of SAS/Access). The Import Wizard even lets you
handle fixed-length files if you are willing to define the formats to read
the variables in.
There are file conversion programs avaialable as well (whose names escape me
at the moment - Concentric?) that will translate to SAS dataset format.
> -----Original Message-----
> From: Talbot Michael Katz [mailto:TopKatz@EMAIL.MSN.COM]
> Sent: Monday, July 23, 2001 11:38 AM
> Subject: Data Input Packages for SAS?
> I know that SAS already has impressive capabilities to read many different
> types of incoming files, especially if you have SAS/ACCESS. But does
> anyone know of package(s) that make it easy / automatic for SAS to read
> fixed-length, variable-length, comma-delimited, and other common, but
> possibly messy filetypes? Thanks!
> -- TMK --