topic Re: ADVANCE Certification Book Chapter 2 Q5 in SAS Certification

ADVANCE Certification Book Chapter 2 Q5

rimal_mahesh — Thu, 01 Oct 2020 07:44:04 GMT

5. Which of the following displays the structure of a table in the SAS log?
a. proc sql;
describe as
select *
from certadv.payrollmaster;
quit;
b. proc sql;
describe contents certadv.payrollmaster;
quit;
c. proc sql;
describe table certadv.payrollmaster;
quit;
d. proc sql;
describe * from certadv.payrollmaster;
quit;

5. Correct answer: b
The DESCRIBE TABLE statement lists the column attributes for a specified table.

Looks Obvious C is the answer

Re: ADVANCE Certification Book Chapter 2 Q5

Ksharp — Thu, 01 Oct 2020 12:25:13 GMT

Did you run B code in SAS. B code is not right .

Re: ADVANCE Certification Book Chapter 2 Q5

Mark2010 — Thu, 01 Oct 2020 13:19:43 GMT

I agree with you and will relay to the SAS Press team. The rationale description is correct, but it identifies the wrong answer letter, which should be C rather than B.