WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
A. merge work.employee
work.salary (fname = name);
B. merge work.employee
work.salary (name = fname);
C. merge work.employee
work.salary (rename = (fname = name));
D. merge work.employee
work.salary (rename = (name = fname));
Click Comment link to get answer
Answer is D
ReplyDelete(rename = (name = fname));
ReplyDeletecompletes the merge of the two data sets by the FNAME variable
D
Correct Answer: D
ReplyDeleteBecause the two data sets are merged by fname variable. You need to rename the name variable of the salary data set to fname. Correct way to rename is
(rename = (name = fname))
thank you so much.well and short explanation.
DeleteI tried to submit the (rename=(fname=name)) too. I found SAS 9.1 works. Log indicates the errors. But out present the correct results.
ReplyDeleteanyone please tell me why?
what is the error message you are getting?
ReplyDelete(rename = (original_var_name= new_var_name))
ReplyDeleteThe original var in this case is name and needs to be renamed fname.
So D should be the correct answer.
Thnks; This the way we should answer. Super job.
ReplyDelete(rename = (original_var_name= new_var_name))
The answer is D.
ReplyDeleteD is definately the answer.
ReplyDeleteisnt fname the old name here...
ReplyDeleteSAS mentions I need a minimum of 70% correct to pass the exam, so is it ok if I mark 70% of the questions correct & 30% wrong, will I still be able to pass the test ????
ReplyDeleteabsolutely
DeleteData science course in Gurgaon is likewise for business people who intend to be a data scientist at entry level or higher. Data science training in Gurgaon is regarded as one of the best data science courses in India. After the successful completion of the Data science course in Gurgaon, the student will be given placement assistance just as job support. Real-time training and project support are two salient features of this course.
ReplyDeleteFor More Info: Data Science Training in Gurgaon