I made macro %dataload   and want to load data once by using loop.. not that listing   %dataload(year=16,month=09); %dataload(year=16,month=10); %dataload(year=16,month=11); %dataload(year=17,month=12); %dataload(year=17,month=01); %dataload(year=17,month=02); %dataload(year=17,month=03); %dataload(year=17,month=04); %dataload(year=17,month=05); %dataload(year=17,month=06); %dataload(year=17,month=07); %dataload(year=17,month=08); %dataload(year=17,month=09); %dataload(year=17,month=10); %dataload(year=17,month=11);     can I use do loop? for example   %let start_year=16 %let end_year=18   do i = start_year to end_year; do j= 1 to 12; %dataload(year=i,month=j) end; end; ... View more

I want to load data by using macro but last day is different from month   for example, in feb last day is 31 but in april 30   how can i do..?     %macro dataload(year=17,month=11); proc import out = temp; %if &month=1 or &month=3 or &month=5 or &month=7 or &month=8 or &month=10 or &month=12 %then datafile = "J:\&year..&month.\&20&year.&month.01-20%year.%month.31.xlsx" %else &month= 4 or &month= 6 or &month= 9 or &month= 11 %then datafile = "J:\&year..&month.\&20&year.&month.01-20%year.%month.30.xlsx" %else &month=2 and &year=16 %then datafile = "J:\&year..&month.\&20&year.&month.01-20%year.%month.29.xlsx" %else &month=2 %then datafile =  "J:\&year..&month.\&20&year.&month.01-20%year.%month.28.xlsx" DBMS = XLSX replace; sheet = "sheet1"; run;     %mend %dataload(year=17,month=11); %dataload(year=17,month=10); %dataload(year=17,month=09); ... View more