merging

[olivia123456]

1. Data sets A and B are showing below, apply various SET, MERGE, and UPDATE statements to determine what is contained in the data set C:

Data set   A	Data set  B
Id    X  Y	Id    X     Z
1     10  11 2     14    .	1          .      4 3      15     5 3      17     .

                                                                                       Data set C

		Id	X	Y	Z
(1)	Data C; set A B;
(2)	Data C; set A; set B;
(3)	Data C; set A B; by Id;
(4)	Data C; merge A B;
(5)	Data C; merge A B; by Id;
(6)	Data C; update A B; by Id;
(7)	Data C; set B; If X=. then set A; Else Y=mean(X, Z);

[Astounding]

Are you unable to create the two data sets?

Are you unable to run any of the 7 programs?

[olivia123456]

I was able to create the two data sets. I am confused to what the table is asking from me. I don't understand how to answer it or how to use the set function.

[Astounding]

Try running each of the programs (with a RUN; statement at the end of each), and see what the results are.

The SET statement reads observations from a SAS data set.  You will 100% need to learn that.