Question 62: You have been given below two datasets

 And you apply below program

 data  course100;

 merge course101 course102 ;

 by COURSE_ID;

 run;

 Which of the following statement is correct?

1. For all the same course_id LOCATION value of the first data set course101 will remain as it is and Location from Course102 will be

 discarded.

2. Get all Questions and Answer from here
3. You need to have paid subscription to access all questions
4. Thanks for considering SAS Certification Material

 Correct Answer : 3 Exp : In case of merge if id matches than all the columns which are common will be overwritten by the second dataset. 

You can access to full explanation to question and answer from this page.