Advance Certification book QA

[rimal_mahesh]

Hi,

How many statments? Adv Cert Book  chap 1 2nd question is answer right? What about Quit statement?

2. How many statements does the program below contain?

proc sql;

select grapes,oranges,

grapes + oranges as sumsales

from certadv.produce

order by sumsales;

quit;

1. two
2. three
3. four
4. five

2. Correct answer: a

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.

[jimbarbour]

I would also say three.

[SASJedi]

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". 

[Mark2010]

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.

[larkino · Accepted solution]

The simplest way to calculate numbers of statements - calculate the number of ; (semicolon)