https://communities.sas.com/t5/SAS-Programming/Reading-Excel-File-to-SAS-Data/m-p/613184#M179053 <P>Hi ,</P><P>&nbsp;</P><P>I need help reading multiple excel files at one location and create multiple tables reading all excel files.Please if you can provide me the code</P><P>&nbsp;</P><P>Thanks In Advance,</P><P>Kajal</P> Fri, 20 Dec 2019 03:19:40 GMT kajal_30 2019-12-20T03:19:40Z https://communities.sas.com/t5/SAS-Programming/Reading-Excel-File-to-SAS-Data/m-p/613184#M179053 <P>Hi ,</P><P>&nbsp;</P><P>I need help reading multiple excel files at one location and create multiple tables reading all excel files.Please if you can provide me the code</P><P>&nbsp;</P><P>Thanks In Advance,</P><P>Kajal</P> Fri, 20 Dec 2019 03:19:40 GMT https://communities.sas.com/t5/SAS-Programming/Reading-Excel-File-to-SAS-Data/m-p/613184#M179053 kajal_30 2019-12-20T03:19:40Z https://communities.sas.com/t5/SAS-Programming/Reading-Excel-File-to-SAS-Data/m-p/613187#M179055 <P>You can refer this community post to import all excel files using SAS Macro:</P> <P><A href="https://communities.sas.com/t5/SAS-Programming/importing-all-excel-files-ina-folder/td-p/12820" target="_blank">https://communities.sas.com/t5/SAS-Programming/importing-all-excel-files-ina-folder/td-p/12820</A></P> Fri, 20 Dec 2019 03:48:54 GMT https://communities.sas.com/t5/SAS-Programming/Reading-Excel-File-to-SAS-Data/m-p/613187#M179055 Kalind_Patel 2019-12-20T03:48:54Z