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
| PROC SQL;
CREATE TABLE WORK.PERIM AS SELECT DISTINCT CC0_TREF_PERIMETRE_JOUR.ID_GROUPE,
PERIMETRE_JOUR.NOM_GROUPE,
PERIMETRE_JOUR.ID_ENTREPRISE,
PERIMETRE_JOUR.SIREN,
PERIMETRE_JOUR.CONTRAT,
PERIMETRE_JOUR.RAISON_SOCIALE,
PERIMETRE_JOUR.CRISQ2,
PERIMETRE_JOUR.DT_ENTREE_GROUPE,
PERIMETRE_JOUR.DT_SORTIE_GROUPE
FROM PERIMETRE_JOUR AS PERIMETRE_JOUR
WHERE PERIMETRE_JOUR.NOM_GROUPE = "GROUPE 1";
QUIT;
PROC SQL;
CREATE TABLE WORK.Jointure AS SELECT DISTINCT PRIMES.ACT_DSOIN_MMAA,
PRIMES.OCC_NIV1,
PRIMES.OCC_NIV2,
PRIMES.OCC_NIV3,
PRIMES.BENEF_LIEN1,
PRIMES.BENEF_LIEN2,
PRIMES.MONT_RC,
PRIMES.ACT_NB,
PERIM.NOM_GROUPE,
PERIM.CRISQ2,
PERIM.RAISON_SOCIALE,
PERIM.DT_ENTREE_GROUPE,
PERIM.DT_SORTIE_GROUPE
FROM PRIMES AS PRIMES
LEFT JOIN WORK.PERIMETRE_JOUR AS PERIMETRE_JOUR ON (PRIMES.AFFIL_SIREN = PERIM.SIREN);
QUIT; |
Partager