Hello Arthur, How can we get this kind of a result? O/P 1 1999 (22,30,12) (270,40,14) (32,50,14) - Brackets means a single cell. 2 2000 (18,20,15) (22,33,22) (25,36,320) input ID Year Value1 Value2 Value3; datalines; 1 1999 22 270 32 1 1999 30 40 50 1 1999 . 12 14 1 2000 18 22 25 1 2000 20 33 36 1 2000 15 22 320 1 2001 . 122 . 1 2001 . . . 1 2001 . . 500 ; data want; update have(obs=0) have; by id year; run; Thank you!
... View more