I need to import about 120 Excel files into SAS and merge them into one dataset. Each excel contains data for one sepcific month. The format of each excel is same.
It takes much time to import each excel into sas and append them each time. Is there any quick method to deal with such problem?