Base SAS Certification Questions Series - Part 2

The Global SAS certification exam is administered by SAS and Pearson VUE together. There are 60-65 multiple choice questions in Base SAS certification exam and candidate must achieve 70% score to pass multiple choice questions in  110 minutes.

We had started a series of articles to help you prepare for this examination. Here comes the second one covering few more.

For previous questions refer to :  Base SAS Certification Questions Series - Part 1

Q3. The following SAS program is submitted:

Proc means data = sasuser.houses std mean max;Var sqfeet ;

Run;

Which one of the following is needed to display the standard deviation with only two decimalplaces?

A. Add the option MAXDEC = 2 to the MEANS procedure statement.B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.

Answer of the question is highlighted.

Q4. Which one of the following is true when SAS encounters a data error in a DATA step?

A. The DATA step stops executing at the point of the error, and no SAS data set is created.

B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.
C. A note appears in the SAS log that the incorrect data record was saved to a separate SAS
file for further examination.
D. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.

Answer of the question is highlighted.

Q5. The following SAS program is submitted:

data work.retail;cost = ‘20000’;total = .10 * cost;

run;

Which one of the following is the value of the variable TOTAL in the output data set?

A. 2000B. ‘2000’C. (missing numeric value)D. ‘ ‘(missing character value)

Answer of the question is highlighted.

In fact this is one of the methods to convert character field to numeric. multiply the field with 1 and convert the numbers in character format to numeric format.

Enjoy reading our other articles and stay tuned with ...

Kindly do provide your feedback in the 'Comments' Section and share as much as possible.