Date:         Fri, 26 May 2000 09:01:21 -0700
Reply-To:     Philip Whittall <philip.whittallNOphSPAM@UNILEVER.COM.INVALID>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Philip Whittall <philip.whittallNOphSPAM@UNILEVER.COM.INVALID>
Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here
Subject:      Re: Extracting Data From Databases

If your Omin-thing data base can run a script
and dump things out to an ASCII file as a result
then use a pipe and forget everything except SAS

FILENAME IN PIPE "Execute program to get Omni* to produce
data";

data sasuser.mydata;
     infile in;

data step statements to read the records

....

RUN;

You can be even more slick and use Macros to pass
names to the scripted program and name the data sets.





* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping.  Smart is Beautiful