hello friends, I was stuck on the last part to merge two table. can somebody help me with this. Patients underwent knee replacement surgeries for one or both knees. The data record patient id, the replaced knee number (1 or 2), and satisfaction scores pre-operatively, one day, one week, and one month after the surgery. The data are     Patient         Knee       Score     Score at     Score at     Score at       ID       Number   Pre-op   one day     one week   one month     01           1               0              5                7                 10     02           1               0            10              15                 15     02           2               3              5                8                 10     03           1               0              3                3                   3     03           2               0              6                9                   9     04           1               0              4              10                 10     (a) Use the ARRAY statement to create a data set containing satisfaction scores for knee 1. The data set should look like this                                                       id    visit    score                                         01      1         0                                       01      2         5                                       01      3         7                                       01      4        10                                       02      1         0                                       02      2        10                                       02      3        15                                       02      4        15                                       03      1         0                                       03      2         3                                       03      3         3                                       03      4         3                                       04      1         0                                       04      2         4                                       04      3        10                                       04      4        10    (b) Use the ARRAY statement to create a data set containing satisfaction scores for knee 2. The data set should look like this                                                                id    visit    score                                         02      1         3                                       02      2         5                                       02      3         8                                       02      4        10                                       03      1         0                                       03      2         6                                       03      3         9                                       03      4         9   (c) Use the MERGE statement to create the merged file that looks like this                                                   score_    score_                                id     visit      knee1     knee2                                  01    pre_op        0         .                                01    day 1         5         .                                01    week 1        7         .                                01    month 1      10         .                                02    pre_op        0         3                                02    day 1        10         5                                02    week 1       15         8                                02    month 1      15        10                                03    pre_op        0         0                                03    day 1         3         6                                03    week 1        3         9                                03    month 1       3         9                                04    pre_op        0         .                                04    day 1         4         .                                04    week 1       10         .                                04    month 1      10         . ... View more