Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam A00-211 topic 1 question 11 discussion

Actual exam question from SAS Institute's A00-211
Question #: 11
Topic #: 1
[All A00-211 Questions]

The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?

  • A. The SORT procedures contain invalid syntax.
  • B. The merged data sets are not permanent SAS data sets.
  • C. The RUN statement was omitted alter each or the SORT procedures.
  • D. The data sets were not merged in the order by which they were sorted.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Sai_krishna_
5 months, 2 weeks ago
The Code appears to be correct syntactically, but there's a small issue with the MERGE statement. You should use the BY statement after the MERGE statement to specify the variables by which the datasets are merged.
upvoted 1 times
...
Mouni_18
7 months, 3 weeks ago
Answer D is correct.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...