- data xyz;
- input id$ x y z;
- cards;
- A 12 3 45
- B 11 2 34
- C 10 4 76
- D 23 7 16
- ;
- data uvw;
- input id$ u v w;
- cards;
- A 20 5 50
- B 12 3 32
- C 16 8 99
- f 27 11 15
- ;
- proc sort data=xyz;
- by id;
- proc sort data=uvw;
- by id;
- run;
- data a;
- set xyz;
- set uvw;
- by id;
- proc print noobs;
- run;
- id x y z u v w
- A 12 3 45 20 5 50
- B 11 2 34 12 3 32
- C 10 4 76 16 8 99
- f 23 7 16 27 11 15
- id x y z u v w
- A 12 3 45 20 5 50
- B 11 2 34 12 3 32
- C 10 4 76 16 8 99
- D 23 7 16 . . .
- f . . . 27 11 15