Suppose you want to import multiple excel sheets with the same variable names into a library and then merge data from all the sheets to a single data set.
How to use :
1. Paste the above program into SAS program editor window
2. Change the path mentioned in the first line of program (highlighted below in red)
libname myxl excel 'C:\Deepanshu\SAS\Excel Sheets.xls' ;
3. Run the program