1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
proc sql;
create table TDB25 as SELECT TDB_bul.Code_diplome, TDB_bul.AnSuiv,
sum(eff_app_total17) as eff_app_total17, sum(eff_app_bul_16) as eff_app_bul_16, sum(eff_app_bul_15) as eff_app_bul_15, sum(eff_app_bul_14) as eff_app_bul_14,
sum(PuEFFECTIF_17) as PuEFFECTIF_17,sum(PrEFFECTIF_17) as PrEFFECTIF_17, sum(EFFECTIF_17Tot) as Scol_17Tot,
sum(PuEFFECTIF_16) as PuEFFECTIF_16,sum(PrEFFECTIF_16) as PrEFFECTIF_16, sum(EFFECTIF_16Tot) as Scol_16Tot,
sum(PuEFFECTIF_15) as PuEFFECTIF_15,sum(PrEFFECTIF_15) as PrEFFECTIF_15, sum(EFFECTIF_15Tot) as Scol_15Tot,
sum(PuEFFECTIF_14) as PuEFFECTIF_14,sum(PrEFFECTIF_14) as PrEFFECTIF_14, sum(EFFECTIF_14Tot) as Scol_14Tot,
sum(PuEFFECTIF_13) as PuEFFECTIF_13,sum(PrEFFECTIF_13) as PrEFFECTIF_13, sum(EFFECTIF_13Tot) as Scol_13Tot,
sum(PuEFFECTIF_12) as PuEFFECTIF_12,sum(PrEFFECTIF_12) as PrEFFECTIF_12, sum(EFFECTIF_12Tot) as Scol_12Tot,
sum(eff_app_gars17) as eff_app_filles17, sum(eff_app_gars17) as eff_app_filles17, sum(eff_app_total17) as eff_app_total17,
/*pas de données en 2016*/
sum(Masc_2015) as Masc_2015 , sum(Fem_2015) as Fem_2015, sum(Masc_2015,Fem_2015) as Eff_App_tot2015,
sum(Masc_2014) as Masc_2014 , sum(Fem_2014) as Fem_2014, sum(Masc_2014,Fem_2014) as Eff_App_tot2014
FROM TDB_bul LEFT JOIN Quater_MF ON TDB_bul.AnSuiv = Quater_MF.Annee_suivie AND TDB_bul.Code_diplome = Quater_MF.Code_diplome
GROUP BY TDB_bul.Code_diplome, TDB_bul.AnSuiv;
run;quit; |
Partager