A00-231 Certification - Validate Your Expertise in SAS Base Programming

The A00-231 certification from SAS Institute validates your expertise in SAS base programming. It tests your knowledge of control statements, expressions, loops, and data management concepts. This exam consists of questions based on real-life business scenarios.

Question: 1

Which statement limits a PROC MEANS analysis to the variables Boarded, Transfer, and Deplane?
A. by boarded transfer deplane;

B. var boarded transfer deplane;

C. output boarded transfer deplane;

D. class boarded transfer deplane;

Answer: B

Question: 2

During the compilation phase, SAS scans each statement in the DATA step, looking for syntax errors. Which of the following is not considered a syntax error?
A. invalid options or variable names

B. missing or invalid punctuation

C. incorrect values and formats

D. missing or misspelled keywords

Answer: C

Question: 3

Which of the following PROC PRINT steps is correct if labels are not stored with the data set?
A. proc print data cert.totals label noobs; run;

B. proc print data=cert.totals label; label region8='Region 8 Yearly Totals';run;

C. proc print cert.totals label;run;

D. proc print data=cert.totals; label region8='Region 8 Yearly Totals'; run;

Answer: B

Question: 4

What happens if you submit the following program? proc sort data=cert.stress out=maxrates; by maxhr; run; proc print data=maxrates label double noobs; label rechr='Recovery Heart Rate; var resthr maxhr rechr date; where toler='I' and resthr>90; sum fee; run;

A. SAS log messages indicate that the program ran successfully.

B. A SAS log message might indicate that a quoted string has become too long or that the statement is ambiguous.

C. A SAS log message indicates that an option is not valid or not recognized.

D. A log message might indicate an error in a statement that seems to be valid.

Answer: B

Question: 5

Within the data set Cert.Temp, PayRate is a character variable and Hours is a numeric variable. What happens when the following program is run?
data work.temp; set cert.temp;
Salary=payrate*hours; run;
A. SAS converts the values of Hours to character values. A message is written to the log.

B. SAS converts the values of PayRate to numeric values. No message is written to the log.

C. SAS converts the values of Hours to character values. No message is written to the log.

D. SAS converts the values of PayRate to numeric values. A message is written to the log.

Answer: B