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

A00-231 Certification - Validate Your Expertise in SAS Base Programming
2 min read
16 October 2022

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.

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

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

Question: 6

Which type of delimited file does PROC IMPORT read by default?
A. illogical record-length files

B. varying record-length files

Next Page

In case you have found a mistake in the text, please send a message to the author by selecting the mistake and pressing Ctrl-Enter.
harry calm 2
Joined: 1 year ago
Comments (0)

    No comments yet

You must be logged in to comment.

Sign In / Sign Up