Date:         Fri, 24 Aug 2007 13:55:08 -0700
Reply-To:     wardnine@HOTMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         wardnine@HOTMAIL.COM
Organization: http://groups.google.com
Subject:      Re: Questions on appending numerous datasets...
Comments: To: sas-l@uga.edu
In-Reply-To:  <BAY123-F331B22B0EF9010F7CD04EFDED50@phx.gbl>
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!

Julie