I am trying to run a nested do loop that creates columns "EXP_&i&j" and sets the appropriate values. Currently using the following code below. Unfortunately not seeing any values coming through for i,j,mmdate,eom,numdays,x. Not sure what the issue is. Please help %Do i = 2010 %to 2010; %Do j = 1 %to 2; k = 1; mmdate=mdy(j,k,i); format mmdate ddmmyy10.; enddate = TO_DATE; eom=intnx( 'month', mmdate,0,'end'); numdays=day(eom); x = 0; if mmdate>= start_date and mmdate<= enddate then x = numdays; if year(mmdate)= year(start_date) and month(mmdate)= month(start_date) then x = numdays - day(start_date); if year(mmdate)= year(enddate) and month(mmdate)= month(enddate) then x = day(enddate); EXP_&i&j = x; output; %End; %End; %mend A; %A; run;
... View more