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 34 35 36 37 38
| PROC SQL;
CREATE TABLE TEST2 AS SELECT
NUMCLI,
"PACHET" AS PRODUIT,
SUM (MONT082011) AS MONT082011,
SUM (MONT092011) AS MONT092011,
SUM (MONT102011) AS MONT102011,
SUM (MONT112011) AS MONT112011,
SUM (MONT122011) AS MONT122011,
SUM (MONT012012) AS MONT012012,
SUM (MONT022012) AS MONT022012,
SUM (MONT032012) AS MONT032012,
SUM (MONT042012) AS MONT042012,
SUM (MONT052012) AS MONT052012,
SUM (MONT062012) AS MONT062012,
SUM (MONT072012) AS MONT072012,
SUM (MONT082012) AS MONT082012
FROM FILTER_FOR_BV1_SAS7BDAT_0003
WHERE NUMCLI IN
(SELECT DISTINCT NUMCLI
FROM FILTER_FOR_BV1_SAS7BDAT_0003
WHERE PRODUIT IN ("PACHET", "PNACHET")
GROUP BY NUMCLI HAVING COUNT(DISTINCT PRODUIT) > 1)
GROUP BY NUMCLI
UNION
SELECT
NUMCLI, PRODUIT,MONT082011, MONT092011, MONT102011, MONT112011, MONT122011, MONT012012, MONT022012, MONT032012, MONT042012, MONT052012, MONT062012, MONT072012, MONT082012
FROM FILTER_FOR_BV1_SAS7BDAT_0003
ORDER BY NUMCLI;
QUIT; |
Partager