Date:         Fri, 26 May 2000 09:33:35 +0200
Reply-To:     Claus Gotfred Rasmussen <CGR@ACCEPTCARD.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Claus Gotfred Rasmussen <CGR@ACCEPTCARD.DK>
Subject:      Re: Extracting Data From Databases
Content-Type: text/plain; charset="iso-8859-1"

Hi June,

I aggree with Mike Harris in the point about cutting out the MS Access step.
SAS/Import can easily import a text file.

If you use the point and click version of import, SAS wil generate and
process some code. Then you can go back to the program editor and recall the
program, and revise it yourself. Eg. if some variable needs to be numeric
instead of character or something like that.

If your text-file is in the same format every time you need to import it,
you can possibly create a SAS-macro to do the job for you.

Feel free to mail me for more details.

Regards
Claus

****** Juned wrote:

SAS-Lers,
      Some of the data for the study I am working on is stored in a Omnius 7
database. I had never heard of Omnius until I started working here, but I
know it is not ODBC compliant.
     In order to analyze this data, I have been exporting the data in the
tables to text files and then importing them into a MS Access database. I
then export my MS Access queries into text files and read them into SAS. I
am trying to streamline this process.
     My question is, what is the advantage (if any) of exporting the tables
as .dbf or .dif files and then using SAS/ACCESS to analyze them? Will
exporting them as .dbf files and then using StatTransfer to convert them to
SAS files be just as effective?
     I am using PC SAS 7.0 and some of these Omnius 7 tables have over
300,000 records. Answers to my questions and/or any suggestions on how to
streamline my process would be appreciated. Thanks. -Juned

Juned Siddique
js39@gunet.georgetown.edu