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
>