LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (April 2002, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 19 Apr 2002 13:49:11 -0400
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "S. David Riba" <dave@JADETEK.COM>
Subject:      Re: reading data from a text file through ODBC
Content-Type: text/plain; charset="iso-8859-1"

With all due respect (and VERY humbly, Sig), ODBC has a Text driver which allows the definition of CSV, tab delimited, and custom delimited data sources to ODBC. Been around forever, not well known. You can find it under the File DSN tab in the ODBC Data Source Administrator.

Dave Riba

---------------------------------------------------------------------------- S. David Riba INTERNET: dave@JADETEK.COM JADE Tech, Inc. P O Box 4517 Clearwater, FL 33758 SAS Certified Professional - V6 VOICE: (727) 726-6099 A SAS Alliance Partner SSU 2001 Co-Chair SAS. It's not just an attitude

----- Original Message ----- From: "Sigurd Wilson Hermansen" <hermans1@WESTAT.COM> Newsgroups: To: <SAS-L@LISTSERV.UGA.EDU> Sent: Friday, April 19, 2002 1:31 PM Subject: Re: reading data from a text file through ODBC

> Comma-delimited and text files do not contain the metatdata that ODBC > needs to extract from a data source in order to read it into a SAS > dataset. DBMSCOPY, for example, displays the contents of these files > and helps a user supply the necessary metadata (including informats > for dates, times, numbers, etc.). Sig > > "Daniele Monzali" <> wrote in message news:<a9osnv$14q$>... > > hello all > > does anyone know whether and how it is possibile to configure an ODBC > > textpad driver in order to directly read .csv or .txt data files in SAS ? > > thanks > > daniele >

Back to: Top of message | Previous page | Main SAS-L page