1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| 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,
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,
sum(CAPScoPubl17) as CAPScoPubl17,
sum(CAPScoPubl16) as CAPScoPubl16,
sum(CAPScoPubl15) as CAPScoPubl15,
sum(CAPScoPubl14) as CAPScoPubl14,
sum(PuDIVISIONS_17) as PuDIVISIONS_17, sum(PrDIVISIONS_17) as PrDIVISIONS_17, sum(DIVISIONS_17Tot) as DIVISIONS_17Tot,
sum(PuDIVISIONS_16) as PuDIVISIONS_16, sum(PrDIVISIONS_16) as PrDIVISIONS_16, sum(DIVISIONS_16Tot) as DIVISIONS_16Tot,
sum(PuDIVISIONS_15) as PuDIVISIONS_15, sum(PrDIVISIONS_15) as PrDIVISIONS_15, sum(DIVISIONS_15Tot) as DIVISIONS_15Tot,
sum(PuDIVISIONS_14) as PuDIVISIONS_14, sum(PrDIVISIONS_14) as PrDIVISIONS_14, sum(DIVISIONS_14Tot) as DIVISIONS_14Tot,
sum(PuDIVISIONS_13) as PuDIVISIONS_13, sum(PrDIVISIONS_13) as PrDIVISIONS_13, sum(DIVISIONS_13Tot) as DIVISIONS_13Tot,
sum(PuDIVISIONS_12) as PuDIVISIONS_12, sum(PrDIVISIONS_12) as PrDIVISIONS_12, sum(DIVISIONS_12Tot) as DIVISIONS_12Tot,
Sum(NbrEtabAppr) AS NbrEtabAppr, Sum(NbrEtabScol) AS NbrEtabScol, Sum(NbrEtabScoPub) AS NbrEtabScoPub, Sum(NbrEtabScoPriv) AS NbrEtabScoPriv
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