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
Lavina
1 day ago
D seems right too. If PROC SORT fails, so does PROC PRINT.
upvoted 0 times
...
Shawna
6 days ago
I feel like C could be true. DATA step usually runs fine.
upvoted 0 times
...
Alana
12 days ago
I think A is correct. The error in PROC SORT is a big deal.
upvoted 0 times
...
Gayla
17 days ago
D seems right, both PROC SORT and PROC PRINT had issues.
upvoted 0 times
...
Walton
22 days ago
Wait, are we sure about C? I thought the PROC PRINT would fail too.
upvoted 0 times
...
Sherita
27 days ago
I think B is misleading, not all steps ran successfully.
upvoted 0 times
...
Afton
1 month ago
Totally agree, the log shows a clear error there.
upvoted 0 times
...
Naomi
1 month ago
A) The error in the PROC SORT step caused the program to stop processing.
upvoted 0 times
...
Sabine
1 month ago
I recall that if any step fails, it can impact the subsequent steps, so maybe A or D could be right, but I need to check the log details again.
upvoted 0 times
...
Dominque
2 months 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
2 months 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
2 months 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