How about: data temp; input id     upc_code      year ; cards; 2000351     1230070413     2004 2000351     .     2004 2000351     1230000018     2004 2000351     1230070499     2004 2000351     .     2004 2000351     .     2005 2000351     1230011813     2005 2000351     .     2005 2000351     .     2005 2000351     .     2005 2000351     1230070413     2005 2000351     .     2005 2000351     .     2005 2000351     .     2005 2000351     .     2005 2000351     1230011813     2005 ; run; proc sql ;   select id,year,sum(year) as sum    from temp      group by id,year   union   select .,.,sum(year)as sum    from temp     order by sum ; quit; Ksharp ... View more