Date: Mon, 13 Dec 2010 20:24:11 +1100
Reply-To: john.chapman@virginbroadband.com.au
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: John Chapman <john.chapman@VIRGINBROADBAND.COM.AU>
Subject: Which Dataset is SET Currently Reading?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
If I have a SET statement reading more than one dataset my program can,
of course, know which one it is currently on by using IN= .
But what if I'm doing something like this...
proc sql noprint;
create table work.sales_files as
select memname from dictionary.tables
where upcase(libname='WORK'
and upcase(memname) like 'SALES_%;
select distinct memname into : sales_files separated by ' '
from work.sales_files;
quit;
data x;
set &sales_files.;
run;
What can I put in that data step to give me the name of the dataset SET
is currently reading?
I bet there's an automatic macro symbol holding this information, but
what's it called?