Hello @novinosrin.  Thank you for the reply.  Here is the code I used to generate the subset of PROC PRINT shown below.  But what I want is the ihdi value at obs=8 to fill in obs=9 and 10, the last year for ctryno=1.  I also want ihdi=0.311 at obs=21 to fill in obs=22.  Similarly throughout the data file.  Thanks again.   data want; retain country code year ctryno; set have; by ctryno year; retain _ihdi; if first.code then call missing(_ihdi); if not missing(ihdi) then _ihdi=ihdi; else ihdi=_ihdi; drop _ihdi; proc print data=want;               var code ctryno year ihdi hdi;     ... View more

Hello, I have a similar problem to the one 'aiste' posted.  I tried following the code that worked for them, but it doesn't do what I want.  Below is a print of the 27 obs.  'Code' and 'ctryno' identify countries.  I want to fill in missing values for 'ihdi' with the previous one but only for the same value of 'code'.  I understand that this can't be done for first.code (which is year 2010) if that value is missing, but Given the 2010 value of 'Ango', I want the 2011 value to be the same.  Same for 2011-2013 for "Beli'.  Here is my last code attempt.   data four; set three; by ctryno year; retain _ihdi; if first.ctryno then call missing(_ihdi); if not missing(ihdi) then _ihdi=ihdi; else ihdi=_ihdi; run;   Thanks in advance for any help.     ... View more