Date: Fri, 24 Aug 2007 13:55:08 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: Questions on appending numerous datasets...
Content-Type: text/plain; charset="us-ascii"
On Aug 22, 10:32 am, tobyd...@HOTMAIL.COM (toby dunn) wrote:
> Julie ,
> Use SQL and grab and load all the data set names into a MAcro variable, then
> use that macro variable in your data step.
> Now if you want to use Proc Append you will need to first get all your data
> set names in a SAS data set and then use call execute to build your Proc
> Append code.
> Toby Dunn
I've completed what I was doing for this project... thanks to those
who offered advice. But I'm curious about this suggestion on loading
multiple items into a macro variable? How is this accomplished? For
example, if I have 50 state abbreviations, how would I go about
loading those state abbreviations into a macro variable and how would
the SAS data step go through each "observation" in the macro variable?
I am unfamiliar with this process but I'm sure this would be useful
for future endeavors so any advice here is appreciated, thanks!