Date:         Thu, 5 Jul 2007 12:54:05 -0400
Reply-To:     Michael Raithel <michaelraithel@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Michael Raithel <michaelraithel@WESTAT.COM>
Subject:      Re: PC sas v server
In-Reply-To:  <1183652585.771333.305730@q69g2000hsb.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Dear SAS-L-ers,

> Hi I use PC SAS, but sometimes data files are too big for my PC.
>
> The solution is clearly to have SAS pointing at a server and
> doing the processing on the server with just the reults being
> returned to the pc.  Does this involve getting SAS access or
> is there a way to do this without Access?
>
Matt, interesting... there are two ways that this could be answered:

1. If your data are in a DBMS, you could use, say, SAS/Access to Oracle,
use the Pass-Through facility to extract and process data in Oracle, and
then have the smaller subset passed to your SAS program.  Presumably,
the Oracle server is more powerful than your PC, and you can use
SAS/Access.

2. If you have SAS on a faster, bigger, more powerful server, you could
use SAS/Connect software to process your data on that platform and
either have the smaller subset or the result set passed to your SAS
program.  This would require SAS/Connect on both platforms--your PC and
your faster, bigger, more powerful server.

3. If you have SAS on a faster, bigger, more powerful server, and you
cannot get SAS/Connect software you could schedule a batch process to
crunch the data and then FTP the results to your desktop.

4. <<Add the clever solution of the next SAS-L poster here>>

Matt, best of luck in getting the resources you need to help with your
big files!

I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not
reflect those of my organization or my associates. All SAS code and/or
methodologies specified in this posting are for illustrative purposes
only and no warranty is stated or implied as to their accuracy or
applicability. People deciding to use information in this posting do so
at their own risk.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Michael A. Raithel
"The man who wrote the book on performance"
E-mail: MichaelRaithel@westat.com

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments,
Second Edition
http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172

Author: The Complete Guide to SAS Indexes
http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Everything of importance has been said before by somebody who did not
discover it. - Alfred North Whitehead
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++