Currently I import daily excel files with different dates and then merge them into one big montlhy file. I read on the forum that I can use a macro to automate the process. I am not well versed with macro's, can somebody please shed some light? Thanks
File - 1
Proc IMPORT OUT= Test1
DATAFILE= "/sas/data_20131101.xls"
DBMS=xls REPLACE;
sheet = 7061_newdata;
GETNAMES=YES; MIXED=YES;
run;
File - 2
Proc IMPORT OUT= Test1
DATAFILE= "/sas/data_20131102.xls"
DBMS=xls REPLACE;
sheet = 7061_newdata;
GETNAMES=YES; MIXED=YES;
run;