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;