Hi everyone, I think I have a quite easy problem I cannot solve due to my lack of knowledge of SAS language. For example I've a dataset as follow: Name Year Source File Paper John 2000 X -4 John 2000 Y -3 54 Jack 2000 X 6 5 Jack 2000 Y 8 12 John 2001 X -2 John 2001 Y -1 13 Jack 2001 X 8 12 Jack 2001 Y 12 14 John 2002 X -2 John 2002 Y -1 26 Jack 2002 X 6 5 Jack 2002 Y 8 12 What I whish to do is: if (Name) = Jack and (Source)= X, to copy according to the (Year) the values from (File) into (Paper) where (Name) = John , (Source) = X and (Year) are identical to the one from the row of the selected data. I hope I am clear enough, to sum up I want to fill the blank cells from Paper coresponding to John with the value from File from Jack when Source and Year are identical. Thank you for your help, I am looking for this code for two days and don't succed. Regards, Damien
... View more