How to join two datasets with different observations of a common variable?

[Shradha1]

I have two datasets data1 and data2 with information on students' weight before 1 month and after 1 month respectively. the Number of observations and names of students in both the datasets are not entirely same. How to I join them both to keep all the records in one place.

Data1:

student Weight_before
A             23
B             54
D            23
F            11
G           34
H            27

Data2:

student Weight_after
A 29
B 43
K 54
M 23
G 65
J 18
W 41

I want the final dataset to look like this:

student	Weight_before	Weight_after
A	23	29
B	54	43
D	23	.
F	11	.
G	34	65
H	27	.
K	.	54
M	.	23
J	.	18
W	.	41

How do I achieve this?

Thank you!

[Shmuel · Accepted solution]

Use next code:

proc sort data=data1; by student; run;
proc sort data=data2; by student; run;

data want;
 merge data1 data2;
  by student;
run;