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
| data essai_1;
input id nom$ sexe$ contrat annee;
cards;
1 Mendy M 12 2017
1 Mendy M 12 2017
2 Mendy M 12 2018
2 Mendy M 12 2018
;
run;
data essai_2;
input id S annee;
cards;
1 20 2017
1 20 2017
2 30 2018
;
run;
proc print data=essai_1;
run;
proc print data=essai_2;
run;
proc sql;
create table essai as select
essai_1.id as id1,
essai_1.nom as nom1,
essai_1.sexe as sexe1,
essai_1.contrat as contrat1,
essai_1.annee as annee1,
essai_2.id as id2,
essai_2.S as S2,
essai_2.annee as annee2
from essai_1 left join essai_2
on essai_1.id = essai_2.id
;
quit;
proc print data=essai;
run; |