Exam A00-211 topic 1 question 11 discussion

Actual exam question from SAS Institute's A00-211

Question #: 11
Topic #: 1

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

Suggested Answer: D 🗳️

by Mouni_18 at Sept. 11, 2023, 1:58 p.m.

Comments

Submit Cancel

Sai_krishna_

1 year 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

1 year, 2 months ago

Answer D is correct.

upvoted 1 times

...

Most Voted

Save Cancel

Loading ...

Exam A00-211 All Questions

View all questions & answers for the A00-211 exam

Exam A00-211 topic 1 question 11 discussion

Comments

Sai_krishna_

Mouni_18

Get IT Certification

New Version GCP Professional Cloud Architect Certificate & Helpful Information

The 5 Most In-Demand Project Management Certifications of 2019