topic Is there any quick way to import multiple Excels into SAS and merge them into one dataset in SAS Programming https://communities.sas.com/t5/SAS-Programming/Is-there-any-quick-way-to-import-multiple-Excels-into-SAS-and/m-p/151075#M29804 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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?</P><P>Thanks</P></BODY></HTML> Fri, 31 Oct 2014 02:38:40 GMT ZZB 2014-10-31T02:38:40Z Is there any quick way to import multiple Excels into SAS and merge them into one dataset https://communities.sas.com/t5/SAS-Programming/Is-there-any-quick-way-to-import-multiple-Excels-into-SAS-and/m-p/151075#M29804 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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?</P><P>Thanks</P></BODY></HTML> Fri, 31 Oct 2014 02:38:40 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-any-quick-way-to-import-multiple-Excels-into-SAS-and/m-p/151075#M29804 ZZB 2014-10-31T02:38:40Z Re: Is there any quick way to import multiple Excels into SAS and merge them into one dataset https://communities.sas.com/t5/SAS-Programming/Is-there-any-quick-way-to-import-multiple-Excels-into-SAS-and/m-p/151076#M29805 <HTML><HEAD></HEAD><BODY><P>The answer is in the More Like This beside your post:</P><P></P><P><A _jive_internal="true" href="https://communities.sas.com/message/208571">https://communities.sas.com/message/208571</A></P></BODY></HTML> Fri, 31 Oct 2014 03:27:56 GMT https://communities.sas.com/t5/SAS-Programming/Is-there-any-quick-way-to-import-multiple-Excels-into-SAS-and/m-p/151076#M29805 SASKiwi 2014-10-31T03:27:56Z