https://communities.sas.com/t5/SAS-Programming/Append-excel-import-to-existing-SAS-output/m-p/531607#M145532 <P>Step 1: import to temporary SAS table</P> <P>Step 2: PROC APPEND to the permanent table</P> Thu, 31 Jan 2019 11:20:19 GMT LinusH 2019-01-31T11:20:19Z https://communities.sas.com/t5/SAS-Programming/Append-excel-import-to-existing-SAS-output/m-p/531601#M145530 <P>Hi, I have an excel file (.xlsx) which are named in ddmmmyy format in a folder. I am able to import the files into SAS. Everyday 1 excel file is added to the folder. I already have the code to import it and get it into SAS. Problem occurs when i import today's file into SAS, previous day's file is getting overridden with today's data. Please suggest a way to overcome this issues and automate the code.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 31 Jan 2019 10:40:04 GMT https://communities.sas.com/t5/SAS-Programming/Append-excel-import-to-existing-SAS-output/m-p/531601#M145530 sheetalmahana 2019-01-31T10:40:04Z https://communities.sas.com/t5/SAS-Programming/Append-excel-import-to-existing-SAS-output/m-p/531607#M145532 <P>Step 1: import to temporary SAS table</P> <P>Step 2: PROC APPEND to the permanent table</P> Thu, 31 Jan 2019 11:20:19 GMT https://communities.sas.com/t5/SAS-Programming/Append-excel-import-to-existing-SAS-output/m-p/531607#M145532 LinusH 2019-01-31T11:20:19Z