Linear interpolation for annual data

[SASdevAnneMarie]

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 !

[PaigeMiller · Accepted solution]

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

[SASdevAnneMarie]

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.

[PaigeMiller]

---

@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.

[SASdevAnneMarie]

Thank you!