下面的表格有部分缺失值,需要用另一个表updates更新,请问怎么样用SAS实现自动更新?
| ID | Name | Sex | Age | Height | Weight | Condition |
1 | Alfred | M | 14 | 69 | 112.5 | 1 |
2 | Alice | F | 13 | 56.5 | 84 | 1 |
3 | Barbara | F | 13 | 65.3 | 98 | 1 |
4 | Carol | F | 14 | 62.8 | 102.5 | 1 |
5 | Henry | M | 14 | 63.5 | 102.5 | 1 |
6 | James | M | 12 | 57.3 | 83 | 1 |
7 | Jane | F | 12 | 59.8 | 84.5 | 1 |
8 | Janet | F | 15 | 62.5 | 112.5 | 1 |
9 | Jeffrey | M | 13 | 62.5 | 84 | 1 |
10 | John | M | 12 | 59 | 99.5 | 1 |
11 | Joyce | F | 11 | 51.3 | 50.5 | 1 |
12 | Judy | | 14 | 64.3 | 90 | 0 |
13 | Louise | F | | 56.3 | | 0 |
14 | Mary | | 15 | | 112 | 0 |
15 | Philip | M | 16 | 72 | 150 | 0 |
另一表格数据如下,用来更新上面的表,为方便数据启用,2个表都上转至附件。
| ID | Name | Sex | Age | Height | Weight | Condition |
12 | Judy | F | 14 | 64.3 | 90 | 1 |
13 | Louise | F | 12 | 56.3 | 77 | 1 |
14 | Mary | F | 15 | 66.5 | 112 | 1 |
15 | Philip | M | 16 | 72 | 150 | 1 |