proc expand data=quarter out=temp1 from=qtr to=month; id date; convert gdp / observed=total; run; proc expand data=weekly out=temp2 from=week to=month; id date; convert interest / observed=average; ...