Date: Fri, 8 Oct 1999 18:49:23 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: Deja.com - Before you buy.
Subject: Re: DDE to ODBC
I appreciate the comments, given that I am trying to automate some of
my reporting metrics this most recent approach presents pros and cons.
one it entails an additional piece of human intervention (me via excel
getting the data). However, if I structure my sas approach to dump all
of my results in a "retrieve" directory I could use vb to automate the
process you describe and add an additional component of formatting the
excel in many ways... thanks Aly
In article <email@example.com>,
> I describe this as push/pull. If you push the data from SAS OUT, my
> experience is the same, it is fairly slow. However, if you create the
> data in SAS, then leave SAS, start the other application (Excel in
> case), you can use MS Query (free w/Excel or MS OFfice) to pull the
> data into the application very quickly. In Excel you go to 'Get
> then select ODBC, and walk thru selecting SAS.
> firstname.lastname@example.org (Master Poe) wrote:
> > I too do most of my data management in SAS, then use ODBC to handle
> > summarized data in Excel via Pivot Table....I'm conneted...
> > via 100MB backbone, so my Excel Pivot Tables read the SAS data sets
> > (via ODBC) at about 100,000 records/minute!
> > Before my new network config, however, ODBC worked EXTREMELY slow.
> > hear that Excel2000 Pivot tables (using OLAP) address these issues.
> > On Sat, 02 Oct 1999 17:21:58 GMT, email@example.com wrote:
> > >Right now I am using DDE to dump assorted analytic results from SAS
> > >into Excel97. And I would like to use ODBC. ...
> > >know of a way to open ODBC once and not make a zillion DDE calls?
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Sent via Deja.com http://www.deja.com/
Before you buy.