Proc sql :Insert a Row at the end of the data

SASdevAnneMarie — Fri, 17 Sep 2021 17:12:46 GMT

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 !

Re: Proc sql :Insert a Row at the end of the data

Tom — Fri, 17 Sep 2021 17:56:41 GMT

What is it you want to do?
If you want to add an observation to an existing dataset use PROC APPEND of in PROC SQL use the INSERT statement.

Re: Proc sql :Insert a Row at the end of the data

SASdevAnneMarie — Fri, 17 Sep 2021 18:34:16 GMT

Thank you, Tom,

I don't know how to do it in one step. This code doesn't work :

Re: Proc sql :Insert a Row at the end of the data

PGStats — Fri, 17 Sep 2021 18:55:32 GMT

Insert into is a separate SQL statement. You must end the preceeding statement with a semicolon before the select into statement.

topic Re: Proc sql :Insert a Row at the end of the data in SAS Programming

Proc sql :Insert a Row at the end of the data

Re: Proc sql :Insert a Row at the end of the data

Re: Proc sql :Insert a Row at the end of the data

Re: Proc sql :Insert a Row at the end of the data