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.      ... View more

Hi,  I am using SAS EG 9.4. I have to update monthly data using SAS. Monthly files are named in raw_file_<mmm-yy> format. Columns in all the files are in same order. Below is the code that I used for 2 months- Jul and Aug 18. However, now i need to this activity for past 1 year in same format. Going forward, i will have to do this activity for every month. After this, i need to merge all this files into 1 master file for further analysis. Please help in automating the code using macro to make it efficient and fast.    data work.raw_file_Jul18;         FORMAT                 year_month date9.                 Name $char12.                 Age BEST8.                 department $char12.                 salary dollar12.2;         INFORMAT                  year_month date9.                 Name $char12.                 Age BEST8.                 department $char12.                 salary dollar12.2;          infile "c:/user/data_Jul18"          dlm=';'          MISSOVER          DSD          firstobs=2          lrecl = 32767 ; input           year_month date9.          Name $char12.          Age BEST8.          department $char12.          salary dollar12.2; run;   ... View more