Why is it too long? 26 minutes with summation, but only 0.03 secondes without summation !!! I have 82 columns... How to reduce this slowness? proc sql;
create table pour_TDB.TDB35_A as SELECT Codefinal , GS_final , 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,
etc.........
FROM pour_TDB.TDB35
GROUP BY Codefinal , GS_final, AnSuiv
order by Codefinal; NOTE: Table POUR_TDB.TDB35_A created, with 2272 rows and 82 columns. 1198 run;quit; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. NOTE: PROCEDURE SQL used (Total process time): real time 26:14.24 cpu time 26:11.52 run;quit; *******************************************; proc sql;
create table pour_TDB.TDB35_B as SELECT Codefinal ,GS_final , AnSuiv,
eff_app_total17 as eff_app_total17, eff_app_bul_16 as eff_app_bul_16, eff_app_bul_15 as eff_app_bul_15, eff_app_bul_14 as eff_app_bul_14,
etc ..................
FROM pour_TDB.TDB35
order by Codefinal;
run;quit; NOTE: Table POUR_TDB.TDB35_B created, with 2604 rows and 82 columns. 1243 run;quit; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 secondes cpu time 0.03 secondes NB : I'm not english spoken
... View more