Thank you, Xia, for your help. In case anyone is wondering what I ended up doing, here is what I did. The results are very close to the data that I was getting when I did the interpolation in excel. /*I created an empty dataset with all the ages by 1 so that I would have the correct ages to fill in with the interpolated data:*/ data padded; do age=15 to 44 by 1; output; end; run; /*Then I merged that dummy data set onto my data set that had my 5-year fertility rates:*/ data pad; merge padded work.fert_rates_2012; by age; run; /*Then this is the expand options that I used. The convert has the two fertility rate variables--one for hispanic one for non-hispanic and used the age variable as the ID.*/ proc expand data=pad out=expanded method = spline(natural) extrapolate; id age; convert hisp_irate nonhisp_irate; run;
... View more