1 2 3 4 5 6 7 8 9 10 11
| proc sql;
SELECT COUNT(*) AS nbr_doublon, DT_IMAGE,LB_BO,ID_CONTRAT,CD_PRODUIT,LB_PRODUIT,CD_PRODUIT_SAP,CD_SITE,CD_ASSUREUR,CD_RESEAU,CD_GAR,
LB_GAR,CD_GAR_SAP,CD_RISQ,CD_MT_GAR,ID_GAR_CONTRAT,ID_PREST,CD_TYPE_COMBI_BO ,CD_TYPE_INV,CD_TYPE_MT,DT_CPTA,
CD_STATUT_CALCUL,MT_INV,LB_INFOCENTRE,LB_PROG_SOURCE,DT_HEURE_EXTRACT,CD_UTILISATEUR
FROM Exig_TPROV
GROUP BY DT_IMAGE,LB_BO,ID_CONTRAT,CD_PRODUIT,LB_PRODUIT,CD_PRODUIT_SAP,CD_SITE,CD_ASSUREUR,CD_RESEAU,CD_GAR,
LB_GAR,CD_GAR_SAP,CD_RISQ,CD_MT_GAR,ID_GAR_CONTRAT,ID_PREST,CD_TYPE_COMBI_BO ,CD_TYPE_INV,CD_TYPE_MT,DT_CPTA,
CD_STATUT_CALCUL,MT_INV,LB_INFOCENTRE,LB_PROG_SOURCE,DT_HEURE_EXTRACT,CD_UTILISATEUR
HAVING COUNT(*) > 1;
quit; |
Partager