Hi,
How many statments? Adv Cert Book chap 1 2nd question is answer right? What about Quit statement?
proc sql;
select grapes,oranges,
grapes + oranges as sumsales
from certadv.produce
order by sumsales;
quit;
There are two statements, the PROC SQL statement and the SELECT statement. The
SELECT statement contains three clauses: the SELECT clause, the FROM clause,
and the ORDER BY clause.
I would also say three.
What version of the Certification Prep Guide are you using? I have the "SAS® Certification Prep Guide, Advanced Programming for SAS®9 Fourth Edition". In my copy, quiz question 2 on page page 23 states:
2.How many statements does the program below contain?
proc sql;
select grapes,oranges,
grapes + oranges as sumsales
from sales.produce
order by sumsales;
a.two
b.three
c.four
d.five
For this question, the correct answer would be "a. two".
For the question you posted here, the correct answer would be "b. three".
Hi @SASJedi
That helps explain the issue. Looks like in the latest guide (the one for the Programming Professional credential), a quit; statement was added to the question but not accounted for in the correct answer.
This is a knowledge-sharing community for SAS Certified Professionals and anyone who wants to learn more about becoming SAS Certified. Ask questions and get answers fast. Share with others who are interested in certification and who are studying for certifications.To get the most from your community experience, use these getting-started resources:
Community Do's and Don'ts
How to add SAS syntax to your post
How to get fast, helpful answers
Ready to level-up your skills? Choose your own adventure.