Hi all I have n number of excel sheet. Each excel sheet has 2 worksheet. I want to prepare master sheet where each excel sheet worksheet 1 is concatenated and put in to master excel worksheet 1 and similarly each excel sheet worksheet 2 is combined and put into same master excel but worksheet 2. All teh sheet has same column names and that is not a problem Can any of you let me know is it possible to do this using SAS and if so can you let me know how to approach this ? Thanks Ramanan
... View more