I tried this, but grouping does not happen, I get the same number of lines, KNIV*groupe are repeated proc sql; create table Tab14_16GrpNiv1 as select KNIV, "" as typdip, groupe, sum(tab14_16unionRep._2016total) as NbRep16, sum(tab14_16unionRep._2015total) as NbRep15, sum(tab14_16unionRep._2014total) as NbRep14, sum(tab14_16unionRep._2016total, tab14_16unionRep._2015total, tab14_16unionRep._2014total) as NbRep14_16 from tab14_16unionSort inner join tab14_16unionRep on tab14_16unionSort.code = tab14_16unionRep.code Group by KNIV, "", groupe; quit;
... View more