title: join tables from a library
body: <p>hi am trying to append the data-sets from a library which contain a specific column variable in them.for example i want to append those data-sets which contain the name column in them from myfile library.</p>
  
  <p>below is my sample code---></p>
  
  <pre><code>libname myfile'\c:data';
  
  
  
   proc sql noprint ;
        select distinct catx(".",libname,memname) into :DataList separated by " "
          from dictionary.columns
          where libname = upcase(myfile) and upcase(name);
      quit;
  </code></pre>