/* SAS code */
/* Retrieve the id of the last Interactive Grouping node */
%let cs_guid=;
data _null_;
set &dm_predecessors end=eof;
where component='cs_ign';
if eof then call symputx('cs_guid', guid);
run;
data _null_;
folder = dcreate(strip(symget('cs_guid')), "&dmcas_workpath"); /* Create a folder to put all the files registered */
run;
/* Fetch all registered files under that node */
%dmcas_fetchRegistered(&cs_guid, &dmcas_workpath.&dm_dsep.&cs_guid);
/* Fetch from the dmcas_report table on the data sets */
libname cslib "&dmcas_workpath.&dm_dsep.&cs_guid";
data work.reportTables;
set cslib.dmcas_report;
where upcase(name) in('DATASET', 'FILE');
run;
proc sort data=work.reportTables NODUPKEY;
by VALUE;
run;
/* view the registered files for the node */
proc print data=work.reportTables;
run;
/* this is ign_stats data set */
proc print data=cslib.ign_stats;
run;
libname cslib;
Hi Tom - this code might be a bit of overkill since you know the data set that you want to access, but this should get you what you want I think.
Hope that helps!
... View more
