@DmytroYermak wrote:
Thank you both for the detailed analysis. I wanted to put here my not fancy code but am seeing that have to investigatate yours that is working ).
As long as you are not trying to do many to many merge then it is much easier to code multiple dataset merges using normal SAS code than to trying to force into SQL syntax.
For example you could merge 20 datasets. List the variables you want to drop or keep. And best of all no ***** commas needed.
data want ;
merge t1(in=in1) t2-t20 ;
by x ;
if in1;
drop C D ;
run;