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 28 29 30 31 32 33
| proc sort data=abcazert;
by tsbroadstart;
run;
PROC SQL;
CREATE TABLE somme AS SELECT SUM(itodeliver) AS itodeliver,
SUM(iprocessed) AS iprocessed,
SUM(isuccess) AS isuccess,
((SUM(isuccess)/SUM(iprocessed))*100) AS successpourcent,
SUM(irecipientopen) AS irecipientopen,
((SUM(irecipientopen)/SUM(isuccess))*100) AS ouverturespourcent,
SUM(itotalrecipientopen) AS itotalrecipientopen,
SUM(ioptout) AS ioptout,
((SUM(ioptout)/SUM(isuccess))*100) AS desinscriptionspourcent,
SUM(ipersonclick) AS ipersonclick,
((SUM(ipersonclick)/SUM(isuccess))*100) AS clicsdistinctspourcent,
SUM(itotalrecipientclick) AS itotalrecipientclick,
((SUM(ipersonclick)/SUM(irecipientopen))*100) AS reactivite,
SUM(ireject) AS ireject,
SUM(inewquarantine) AS inewquarantine,
((SUM(inewquarantine)/SUM(isuccess))*100) AS quarantainepourcent,
SUM(imirrorpage) AS imirrorpage,
((SUM(imirrorpage)/SUM(isuccess))*100) AS mirroirpourcent,
SUM(iforward) AS iforward,
((SUM(iforward)/SUM(isuccess))*100) AS transfertspourcent
FROM abcazert;
QUIT;
data tableauavecsommeabcazert;
set abcazert somme;
if sdeliverycode="" then sdeliverycode="Totaux";
run; |
Partager