Hi All,
I am trying to figure out a way to create a dataset which extracts values of a same variable from all datasets in library.
I have many datasets in the library and want to pick up ones having specific variable to generate dataset with their values.
Can be explained in the code below.
Thanks for your help .
/* Have these 3 datasets in work */
data xxx_have1 ;
subject=1 ;output;
environment='prod' ;output;
run;
data abc_have2 ;
subject=1 ;output;
environment='test' ;output;
run;
data xyz_have3 ;
subject=1 ;output;
environment='test2' ;output;
run;
/* get ENVIRONMENT variable from above datasets */
data meta ;
set sashelp.vcolumn;
where libname='WORK' and find (upcase (memname) ,'HAVE') and find (upcase (name) ,'ENVIRONMENT') ;
run;
/* objective - loop through above dataset and create want dataset which has dataset name appended to var name. */
data want;
environment_xxx_have1='prod' ;
environment_abc_have2='test' ;
environment_xyz_have3='test2' ;
run;
... View more