Hello @babu-in  1. Moving from SUSE EL to RHEL should noth have any issue. 2. Have SAS Midtier on its own server. You may be having your data and  processing in the Hadoop cluster.   SAS Access Interface to Hadoop will help you connect to the data in Hadoop. https://www.sas.com/en_us/software/access-interface-hadoop.html ) ... View more

Of course . It is SAS better convenient. Just one LIBNAME statement.   filename xx 'c:\temp\xx.json'; libname x json fileref=xx; proc copy in=x out=work; run; ... View more

@babu-in  On this level the best answer I can give is "it depends". Assuming both data sets are SAS tables what normally takes the most time is sorting and writing data to disk. That's either a Proc Sort with a data step merge or then a SQL Join. But also the SQL join will sort and write data to disk as intermediary temporary files in UTILLOC.   "and try to merge only few variables from second table" IF you can fit these few variables into memory then most likely a data step hash lookup would perform best as this doesn't require any sort operations and reduces write operations to disk. ... View more