Hello Experts,
I'm wondering how to insert on proc sql the row at the and of data with the value LB_UT="Another value"
My code is :
proc sql;
create table test as select rga.LB_LONG as LB_UT from PSAEU11.DB_RGA rga, PSAEU11.DB_DOSSIER sousc, PSAEU11.DB_CTRAT_SUPPORT db_ctrat,
PSAEU11.DB_PROTOCOLE proto, PSAEU11.DB_TIERS tiers1,
PSAEU11.DB_PERSONNE personne1,
PSAEU11.DB_PORTEFEUILLE portef, PSAEU11.DB_TIERS tiers2, PSAEU11.DB_PERSONNE personne2,
PSAEU11.DB_TIERS tiers3, PSAEU11.DB_PERSONNE personne3
where personne2.S_RAISONSOC="UBS (FRANCE) S.A." and personne3.S_RAISONSOC="AMPLEGEST" and sousc.CD_DOSSIER in ('CHOP','CHOC') and sousc.LP_ETAT_DOSS not in ('ANNUL','A30','CLOSE')
and sousc.IS_DOSSIER=db_ctrat.IS_DOSSIER
and sousc.is_protocole=proto.is_protocole
and sousc.is_tiers=tiers1.is_tiers
and tiers1.is_personne=personne1.is_personne
and (db_ctrat.ID_FAMILLE_PORTEF||' '||db_ctrat.ID_PORTEFEUILLE)=(portef.ID_FAMILLE_PORTEF||' '||portef.ID_PORTEFEUILLE)
and portef.is_tiers_depositaire=tiers2.IS_TIERS
and tiers2.is_personne=personne2.IS_PERSONNE
and sousc.IS_TIERS=tiers3.IS_TIERS
and tiers3.is_personne=personne3.is_personne
and db_ctrat.IS_RGA=rga.IS_RGA;
quit;
Thank you very much !
... View more
