topic Re: Advance Certification book QA in SAS Certification

Advance Certification book QA

rimal_mahesh — Tue, 29 Sep 2020 18:03:24 GMT

Hi,

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

How many statements does the program below contain?

proc sql;

select grapes,oranges,

grapes + oranges as sumsales

from certadv.produce

order by sumsales;

quit;

two
three
four
five

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.

Re: Advance Certification book QA

jimbarbour — Thu, 01 Oct 2020 06:00:14 GMT

I would also say three.

Re: Advance Certification book QA

SASJedi — Thu, 01 Oct 2020 14:45:48 GMT

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

Re: Advance Certification book QA

Mark2010 — Thu, 01 Oct 2020 14:49:21 GMT

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.

Re: Advance Certification book QA

larkino — Tue, 27 Oct 2020 16:26:23 GMT

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