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
%do i = 1 %to 7;
i = &i;
select 'WORK.' || memname into :set_list separated by ' '
where libname = 'WORK'
and memname eqt 'DAT'
data all; /* could be a view as well */
From: David Kellerman [mailto:kellermandavid@YAHOO.COM]
Sent: February 6, 2003 11:47 AM
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.
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now