Date:         Wed, 24 Jan 2007 02:45:52 -0800
Reply-To:     Tree Frog <tree.frog2@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tree Frog <tree.frog2@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: data-driven solution
Comments: To: sas-l@uga.edu
In-Reply-To:  <BAY103-F3484E183135426E0A590BB0AC0@phx.gbl>
Content-Type: text/plain; charset="us-ascii"

David L Cassell wrote:

> I just thought I would point out that if you really are going to have this
> many customers and this many graphs per customer, then you are likely
> to have too many calls to PROC EXECUTE for your own good.
>
> This has been discussed in SAS-L before, and I believe that Master Ian
> (Ian Whitlock, to those who have not mastered The Force) has published
> in SAS-L posts some recommendations that oyu might be ableto find in the
> SAS-L archives.
>
> But if you are going to have hundreds of thousands of CALL EXECUTE
> statements, you are likely to overflow the queue these go into, and
> wreak havoc with your plan.
>
> So you might have to re-think the design a bit.
>
> HTH,
> David
> --
> David L. Cassell
> mathematical statistician
> Design Pathways
> 3115 NW Norwood Pl.
> Corvallis OR 97330
>
> _________________________________________________________________
> Get in the mood for Valentine's Day. View photos, recipes and more on your
> Live.com page.
> http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701

David - thanks for this insight.  Having not started coding - I'm still
very much in the planning stage - do you have a suggestion that doesn't
involve CALL EXECUTE?  You're right, there are going to be a LOT of
customers/graphs.  I'm hunting through the SAL-L archives.

It strikes me that this would be a fairly common type of task to design
a SAS routine for... does anyone know of anything like it?

Thanks again

TF