Date:         Sun, 13 Jan 2002 11:13:17 -0500
Reply-To:     "Richard W. Graham" <glencairnconsulting@earthlink.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: Eric Parks <eric.s.parks@GSK.COM>
From:         "Richard W. Graham" <glencairnconsulting@EARTHLINK.NET>
Organization: Glencairn Consulting Group
Subject:      Re: Text imports
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset="iso-8859-1"

Perhaps rather than exporting the Sybase data to text file you might want to
explore SAS's LIBNAME Sybase engine option.  The basic format is as follows:

libname mydblib sybase user=testuser password=testpass;

Take a look at SAS's help.  On the Index tab, just type in Sybase.

In the SAS explorer window, you will see the library.  double click the
library and you will see your Sybase tables.  They'll look like data sets.

Richard W Graham
Glencairn Consulting Group

----- Original Message -----
From: "Eric Parks" <eric.s.parks@GSK.COM>
To: <SAS-L@LISTSERV.VT.EDU>
Sent: Friday, January 11, 2002 9:29 AM
Subject: Text imports


> All,
>
> Can anyone give me any insight into how well SAS handles text imports?
>  I've been asked by my boss to look into the feasibility of taking
> data from our Sybase servers and getting into SAS.  I was thinking of
> writing something to export our tables to text files on our network
> where our SAS people could pick them up, but I'm not sure how well
> that will work on the SAS end of things.  Any thoughts?
>
> Thanks in advance!
> Eric Parks
> Collegeville, PA
>