Append excel import to existing SAS output

sheetalmahana · Posted 01-31-2019 05:40 AM

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.

LinusH · Posted 01-31-2019 06:20 AM

Step 1: import to temporary SAS table

Step 2: PROC APPEND to the permanent table

Data never sleeps

Append excel import to existing SAS output

Re: Append excel import to existing SAS output

Registration is open

SAS Training: Just a Click Away