Question 68: You have been given below dataset

 You run the below program

 data  course100 (drop=COURSE_ID);

 merge course101 (in=in_first rename=(DATE=TRAINING_DATE))

 course102 (drop=FEE in=in_second rename=(DATE=REGISTRATION_DATE)) ;

 by  COURSE_ID;

 if in_first and in_second;

 run;

 What is the output?

1. Merged data will be generated wherever column name matches and course_id will be dropped.
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 : Whenver you want to drop the columns but want them to use during processing than you should not drop them in merge statement

 from individual dataset.

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