topic Automation of multipe excel files and appending those in sas eg in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Automation-of-multipe-excel-files-and-appending-those-in-sas-eg/m-p/173257#M13276 <HTML><HEAD></HEAD><BODY><P>Friends,</P><P>In a project i am getting an 5 excel files every day and want to append these files in sas eg so can you please provide me sas macro code so i can import and append all this at one go.</P></BODY></HTML> Wed, 18 Feb 2015 14:56:59 GMT Fox_3 2015-02-18T14:56:59Z Automation of multipe excel files and appending those in sas eg https://communities.sas.com/t5/SAS-Enterprise-Guide/Automation-of-multipe-excel-files-and-appending-those-in-sas-eg/m-p/173257#M13276 <HTML><HEAD></HEAD><BODY><P>Friends,</P><P>In a project i am getting an 5 excel files every day and want to append these files in sas eg so can you please provide me sas macro code so i can import and append all this at one go.</P></BODY></HTML> Wed, 18 Feb 2015 14:56:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Automation-of-multipe-excel-files-and-appending-those-in-sas-eg/m-p/173257#M13276 Fox_3 2015-02-18T14:56:59Z Re: Automation of multipe excel files and appending those in sas eg https://communities.sas.com/t5/SAS-Enterprise-Guide/Automation-of-multipe-excel-files-and-appending-those-in-sas-eg/m-p/173258#M13277 <HTML><HEAD></HEAD><BODY><P>See</P><P></P><P><A class="jive-link-external-small" href="http://www.sascommunity.org/wiki/Streamlining_Data-Driven_SAS_With_The_%25FOR_Macro">http://www.sascommunity.org/wiki/Streamlining_Data-Driven_SAS_With_The_%25FOR_Macro</A></P><P></P><P>Scroll down to the last example named "<SPAN class="mw-headline" id="Import_all_spreadsheets_in_all_subfolders_of_a_top_folder">Import all spreadsheets in all subfolders of a top folder</SPAN>"</P><P></P></BODY></HTML> Wed, 18 Feb 2015 15:05:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Automation-of-multipe-excel-files-and-appending-those-in-sas-eg/m-p/173258#M13277 PaigeMiller 2015-02-18T15:05:33Z Re: Automation of multipe excel files and appending those in sas eg https://communities.sas.com/t5/SAS-Enterprise-Guide/Automation-of-multipe-excel-files-and-appending-those-in-sas-eg/m-p/173259#M13278 <HTML><HEAD></HEAD><BODY><P>Go back to source and ask them to supply data in a format other than Excel.&nbsp; Even getting it in CSV format will allow you to write robust datastep imports, with wildcards so you don't need to loop over files.</P><P>Not particularly heplfull I know, but it will save you some headaches.&nbsp; I will lay money on something will change in one of those Excel files at least once per import which will break your code.</P></BODY></HTML> Wed, 18 Feb 2015 15:25:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Automation-of-multipe-excel-files-and-appending-those-in-sas-eg/m-p/173259#M13278 RW9 2015-02-18T15:25:12Z