LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (February 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sun, 23 Feb 2003 13:47:59 +0100
Reply-To:     Bart.Heinsius@eomdata.nl
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bart Heinsius <Bart.Heinsius@EOMDATA.NL>
Subject:      Re: multi thread sas in Datawarehousing environment
In-Reply-To:  <a5eg5vsqi0slfrj4sb3aduj3hrsfrb9bk1@4ax.com>
Content-Type: text/plain; charset="iso-8859-1"

Scott,

> 1. How could SAS look at a unique key and split the data based on > that key. I don't understand what you want to do here.

> 2. Can one sas job spawn numerous other's to accomplish what I am > doing executing sas in a unix env. (#3 above). Yes. Take a look at MP CONNECT at http://support.sas.com/rnd/scalability/connect/mp.html.

Cheers, Bart.

> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of > scott sanders > Sent: zondag 23 februari 2003 4:10 > To: SAS-L@LISTSERV.UGA.EDU > Subject: multi thread sas in Datawarehousing environment > > > I work in a datawarehouseing environment where I have to execute sas > code against hundreds of millions of rows. > > The process I have now works well > > 1. Create a table in oracle with all my attributes necessary for sas > excecution > 2. Create another table in oracle with 20 partitions (essentially same > # of obs per partition) > 3. Kick of 1 sas job per partition (20). > > It has the effect of multi-threading and runs fast. > > My question: > > If I could only create one table without any partitions.... > > 1. How could SAS look at a unique key and split the data based on > that key. > 2. Can one sas job spawn numerous other's to accomplish what I am > doing executing sas in a unix env. (#3 above). > > Any ideas would be greatly appreciated. Thanks in advance. > > scott >


Back to: Top of message | Previous page | Main SAS-L page