Date: Mon, 24 Mar 2008 08:47:24 -0700
Reply-To: sonik son <sonikson@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: sonik son <sonikson@GMAIL.COM>
Subject: Global Variable Creation
Content-Type: text/plain; charset=ISO-8859-1
I've read through the numerous posts on creating global variables
here, but have been unable to create code that works for me. So, here
I've been tasked with a new process which involves generating a
dataset of customer accounts from our 50 branches, then sending as
list each branch's accounts to them. This is a weekly process and not
every branch will have accounts any given week.
My weekly branch account dataset is roughly set up in this fashion:
input branch_id account_nbr;
I'd like to set up a process whereby I can automatically read the
branch_id's which appeared on the weekly report, create a dataset of
accounts for that branch_id (named for each branch_id, e.g.
"work.br802", work.br806", "work.br811",) then export them to Excel.
Currently, this is a manual process (and it is killing me.) I have
experimented using CALL SYMPUT and CALL EXECUTE examples from old SUGI
papers, but I have not been able to successfully translate those
approaches to my particular issue.
I appreciate any input or guidance any has to offer.