Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

SAS A00-215 Exam - Topic 10 Question 63 Discussion

You submit a program and the SAS log is shown below:Which statement is true regarding the submitted program?
C) The DATA step and PROC PRINT steps ran without errors.
A) The error in the PROC SORT step caused the program to stop processing
B) All three steps ran successfully
D) The PROC SORT and PROC PRINT steps failed.

SAS A00-215 Exam - Topic 10 Question 63 Discussion

Actual exam question for SAS's A00-215 exam
Question #: 63
Topic #: 10
[All A00-215 Questions]

You submit a program and the SAS log is shown below:

Which statement is true regarding the submitted program?

Show Suggested Answer Hide Answer
Suggested Answer: C

The correct answer is C. The DATA step and PROC PRINT steps ran without errors. In the SAS log shown, there is a clear error in the PROC SORT step because of the use of an incorrect option by ascending Increase which caused the 'Variable ASCENDING not found' error. However, the DATA step completed successfully, as indicated by the 'NOTE' that follows it, confirming that 56 observations were read from the SASHELP.SHOES data set where Region is Africa. Additionally, the PROC PRINT step also completed successfully, indicated by the 'NOTE' at the bottom of the log which confirms that 56 observations were read from the WORK.AFRICA data set, implying the PROC PRINT step executed without issue.

A is incorrect because the error in PROC SORT did not cause the program to stop; SAS continued processing the next steps. B is incorrect because the PROC SORT step did not run successfully. D is incorrect because the PROC PRINT step did not fail; it ran successfully.


SAS documentation on error messages.

Understanding the SAS log and error messages.

Contribute your Thoughts:

0/2000 characters
Dominque
3 days ago
I’m leaning towards D because if PROC SORT fails, it might affect PROC PRINT too, but I’m not completely confident about that.
upvoted 0 times
...
Aron
8 days ago
I'm not entirely sure, but I feel like I saw a similar question where the DATA step ran fine even if PROC SORT had issues. Could C be the answer?
upvoted 0 times
...
Raina
13 days ago
I think I remember that if there's an error in PROC SORT, it usually stops the whole program, so maybe A is correct?
upvoted 0 times
...

Save Cancel