CODEWITHSUNDEEP
sassas-macro
Apache11
Apache11

Reputation: 189

join tables from a library

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.

below is my sample 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;

Upvotes: 0

Views: 91

Answers (1)

Reeza
Reeza

Reputation: 21264

Assuming that the type of the variable is consistent across all datasets something as simple as SET will work:

Data want;
      Set &datalist;
Run;

Upvotes: 2

Related Questions