Date:         Thu, 6 Feb 2003 11:56:04 -0500
Reply-To:     "Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM>
Subject:      Re: Processing AGE datasets
Content-Type: text/plain; charset="iso-8859-1"

The dataset names may be found in the SASHELP.VTABLE view ( replace WORK
with your library name ).  The "selecting off specific records" I'll leave
to you.

%macro create;
  %do i = 1 %to 7;
     data dat&i;
       i = &i;
     run;
  %end;
%mend create;

%create

proc sql;
  select 'WORK.' || memname into :set_list separated by ' '
    from sashelp.vtable
   where libname = 'WORK'
     and memname eqt 'DAT'
  ;
quit;

data all;   /* could be a view as well  */
  set &set_list;
run;

                -----Original Message-----
                From:   David Kellerman [mailto:kellermandavid@YAHOO.COM]
                Sent:   February 6, 2003 11:47 AM
                To:     SAS-L@LISTSERV.UGA.EDU
                Subject:        Processing AGE datasets

                I have a group of datasets in a database created by
AGEing... i.e.: DAT1;DAT2;DAT3;DAT4 ... DATxxx.(maximum 100)

                Perhaps I am going about this the hard way, but I want to be
able to process the x number of datasets in a loop, selecting off specific
records from each dataset.  I can't use a SET statement because I do not
know in advance how many datasets there are.  I attempted to write a macro
to go through, but have not been able to get it to work as yet.

                Any suggestions.  I would think if SAS created the AGEing
process, there would be a simple way to process each dataset in the group.

                David



                ---------------------------------
                Do you Yahoo!?
                Yahoo! Mail Plus - Powerful. Affordable. Sign up now