topic Re: How to I interpolate values in an array? in New SAS User

How to I interpolate values in an array?

DiegoMaxwell — Sat, 01 Feb 2020 11:43:58 GMT

Basically I have some rates that I need to interpolate for a specific date range, so for example if the 'GN Term (M)' is 0.6, I need to use to approximation between the CAD Fixed_2W and the CAD Fixed_3W. I've set up the arrays below, but in the IF statement I am trying to get that linear interpolated approximation based on what the 'GN Term (M)'n is. Just looking for some ideas on how I might accomplish this in SAS?

Re: How to I interpolate values in an array?

PaigeMiller — Sat, 01 Feb 2020 12:02:36 GMT

Can you show us a portion of the data? I'm afraid this description is not clear and complete enough for us to advise. You also mention array in the title and then don't speak about arrays in the text.

I need to use to approximation between the CAD Fixed_2W and the CAD Fixed_3W

This also doesn't have any concrete meaning to me, what "approximation"??

Re: How to I interpolate values in an array?

ballardw — Mon, 03 Feb 2020 17:00:01 GMT

@DiegoMaxwell wrote:

Basically I have some rates that I need to interpolate for a specific date range, so for example if the 'GN Term (M)' is 0.6, I need to use to approximation between the CAD Fixed_2W and the CAD Fixed_3W. I've set up the arrays below, but in the IF statement I am trying to get that linear interpolated approximation based on what the 'GN Term (M)'n is. Just looking for some ideas on how I might accomplish this in SAS?

It appears that you may have intended to post code but it didn't make it.

Easiest is generally to copy the code from your SAS Editor and paste into a code box on the forum opened with the {I} icon.