topic merging in SAS Programming

merging

olivia123456 — Sun, 31 Mar 2019 23:22:39 GMT

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);

Re: merging

Astounding — Sun, 31 Mar 2019 23:31:20 GMT

Are you unable to create the two data sets?

Are you unable to run any of the 7 programs?

Re: merging

olivia123456 — Mon, 01 Apr 2019 20:13:27 GMT

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.

Re: merging

Astounding — Mon, 01 Apr 2019 20:16:46 GMT

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.