topic Re: Linear interpolation for annual data in SAS Programming

Linear interpolation for annual data

SASdevAnneMarie — Wed, 18 Jan 2023 14:37:04 GMT

Hello Experts,

I have a code on R ( I do not code on R):

#if(noms == "Real Estate")
if(noms == Qimmo)
{
interpolation <- c()
date_affichage <- c()

for(annee in 1:(dim(tableau)[1]-1))
{
date_interpolation <- format(seq(as.Date(tableau$Date[annee], "%d/%m/%Y"), as.Date(tableau$Date[annee+1], "%d/%m/%Y"), by="days"), format = "%d/%m/%Y")
interpolation <- c(interpolation, approx(x = annee:(annee+1), y = tableau$Valeur[annee:(annee+1)], n=length(date_interpolation))$y )
date_affichage <- c(date_affichage, date_interpolation)
}

tableau <- data.frame(Date = unique(date_affichage), Valeur = unique(interpolation))
}

Do you know, please, the equivalent of this function on SAS please ? On Internet I have a lot of results, but I don't know which one is correct.

I have joined the data : I would like to have the values for all days in the year.

Thank you for your help !

Re: Linear interpolation for annual data

PaigeMiller — Wed, 18 Jan 2023 14:30:22 GMT

I don't know R either, and all you say to point us in the right direction is these few words in the title: "Linear interpolation for annual data". You can follow these instructions: https://support.sas.com/kb/24/560.html

Re: Linear interpolation for annual data

SASdevAnneMarie — Wed, 18 Jan 2023 14:35:56 GMT

Thank you,
My prolem is that I don't know how to do the linear interpolation for annual data. I have joined the data to my e-mail.

Re: Linear interpolation for annual data

PaigeMiller — Wed, 18 Jan 2023 14:37:53 GMT

@SASdevAnneMarie wrote:

My prolem is that I don't know how to do the linear interpolation for annual data. I have joined the data to my e-mail.

I guess I don't understand why you say that you don't know how ... the link I gave offers actual SAS code to do linear interpolation.

Re: Linear interpolation for annual data

SASdevAnneMarie — Fri, 20 Jan 2023 21:07:57 GMT

Thank you!