@Frank_johannes wrote: . Sorry, 'Variable' was a typo. I mean, of course, all the values from the column 'Varname.' Let me give you a specific example. The table 'AB' exists in 6 differentiere versions in my data warehouse: AB2010 AB2011 AB2012 AB2013 AB2014 AB2015 Not all variables from the 'Varname' column from my ‘meta tabel’ are present in all 6 files. 'Varname' exists only between the start and end periods. I would like to create a PROC SQL with a dynamic SELECT statement that automatically loads tables AB2010-AB2015 (also CD afterwards) with the variables present in the table from the iteration. Is it better explained now?"
Not clear at all.
I do not know what you mean by "loads tables with variables"?
Do you mean you want to read only from datasets that actually have one of the variables of interest?
In that case wouldn't it be better to just have the list of all of the variables for all of the datasets? Basically the output of PROC CONTENTS for the whole library? Then you could just query that to get the list of dataset to read.
proc sql noprint;
select catx('.',libname,memname) into :abc_dslist separated by ' '
from contents
where lowcase(name) = 'abc'
;
data abc ;
set &abc_dslist;
run;
... View more