Date:         Mon, 22 Jan 2007 11:07:29 -0500
Reply-To:     "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject:      Re: data-driven solution
Content-Type: text/plain; charset="us-ascii"

Q: is your Cust-id+graph-id table unique?
   if so then you can feed that table directly into

data _Null_;
set  Cust-id+graph-id;
call execute(...);

see rest of code in:

http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0701B&L=sas-l&P=R11059

Ron Fehd  the call macro
           w/ call execute maven  CDC Atlanta GA USA RJF2 at cdc dot gov


> From: Tree Frog

> I would like to write a program to generate several graphs in
> a single document for each unique value of "customer_id".
> The graphs generated, which are pre-defined, for each
> customer would be determined by data structured as follows,
> most likely stored in a SAS dataset.
>
> customer_id graph_id
> 1 1
> 1 3
> 1 7
> 2 4
> 3 1
> 3 2
> 3 4
> 3 7
> ...
>
> In this example, then, three documents (ie html files, for
> example) would be produced, the first, for customer 1,
> containing graphs 1, 3 and 7; the second, for customer 2,
> containing graph 4; etc.
>
> I'm interested in possible approaches to this, especially
> suggestions which may have performance advantages.
> Ultimately, there are likely to be thousands of customers,
> and a suite of about 100 potential graphs.