@ed_sas_member Thank you very much! This also works very nice. And I was even able to generalize it... PROC SQL;
CREATE TABLE WORK.WANT AS
SELECT t1.year,
t1.id,
t1.value,
t2.id AS idTM1,
t2.value AS valueTM1,
t3.id AS idTM2,
t3.value AS valueTM2,
t4.id AS idTP1,
t4.value AS valueTP1,
t5.id AS idTP2,
t5.value AS valueTP2
FROM WORK.HAVE t1
LEFT JOIN WORK.HAVE t2 ON (t1.year-1 = t2.year) AND (t1.id = t2.id)
LEFT JOIN WORK.HAVE t3 ON (t1.year-2 = t3.year) AND (t1.id = t3.id)
LEFT JOIN WORK.HAVE t4 ON (t1.year+1 = t4.year) AND (t1.id = t4.id)
LEFT JOIN WORK.HAVE t5 ON (t1.year+2 = t5.year) AND (t1.id = t5.id)
ORDER BY t1.year,
t1.id;
QUIT;
... View more
