hello, i need a solution for this programming problem. ,thank u

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 .

(d) Turn in your SAS code as well as the output it produces.