Free SAS A00-231 Exam Actual Questions

The questions for A00-231 were last updated On Apr 25, 2025

At ValidExamDumps, we consistently monitor updates to the SAS A00-231 exam questions by SAS. Whenever our team identifies changes in the exam questions,exam objectives, exam focus areas or in exam requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these actual questions, our customers can successfully pass the SAS 9.4 Base Programming - Performance-Based Exam exam on their first attempt without needing additional materials or study guides.

Other certification materials providers often include outdated or removed questions by SAS in their SAS A00-231 exam. These outdated questions lead to customers failing their SAS 9.4 Base Programming - Performance-Based Exam exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions, guaranteeing their presence in your actual exam. Our main priority is your success in the SAS A00-231 exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.

 

Question No. 1

SIMULATION

Scenario:

This project will use data setcert.input04. At any time, you may save your program asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.

In this program, complete the following mathematical actions, in the following order:

Round VAR1 and VAR2 to the nearest integer values.

Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3.

Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.

For observation 16, what is the value ofVAR3? Enter your numeric answer in the space below:

Show Answer Hide Answer
Correct Answer: A

SAS code that could be used to solve this project:

data results.output04;

set cert.input04;

var3=round(var1,1)*round(var2,1);

var20=sum(of var12-var19);

run;

proc print data=results.output04 (obs=16 firstobs=16);

var var3 var20;

run;

The 'obs' option controls the last observation SAS processes. If you set obs=16, SAS would read and process only up to the 16th observation in the data set.

The 'firstobs' option controls the starting observation. If you set firstobs=16, SAS would start reading and processing from the 16th observation.


Question No. 2

Given the following data set:

Which type of statement was included as a component of a transpose procedure step to produce the following data set?

Select one:

Show Answer Hide Answer
Correct Answer: D

Question No. 3

The following SAS program is submitted:

Which output is correct?

Show Answer Hide Answer
Correct Answer: B

Question No. 4

SIMULATION

Scenario:

This project will use data set cert.input08a and cert.input08b. At

any time, you may save your program

as program08 in cert\programs.

Both data sets contain a common numeric variable named ID.

Write a program that will use a SAS DATA Step to:

o Combine data sets cert.input08a and cert.input08b by

matching values of the ID variable.

o Write only observations that are in both data sets to a

new data set named results.match08.

o Write all other non-matching observations from either

data set to a new data set named results.nomatch08.

o Exclude all variables that begin with

"ex" from results.nomatch08.

How many variables (columns) are in _______________ results.nomatch08

Enter your numeric answer in the space below:

Save your program as ______________ program08.sas in folder cert programs

before continuing with the next project.

Show Answer Hide Answer
Correct Answer: A

SAS code that could be used to solve this project:

Proc

sort data=cert.input08a out=work.input08a;

by ID;

run;

proc sort data=cert.input08b out=work.input08b;

by ID;

run;

data results.match08 results.nomatch08 (drop=ex: );

merge work.input08a (in=a) work.input08b (in=b);

by ID;

if a and b then output results.match08;

else output results.nomatch08;

run;

proc contents data=results.match08;

run;

proc contents data=results.nomatch08;

run;

The correct answer is: 5


Question No. 5

SIMULATION

Scenario:

This project will use data setcert.input04. At any time, you may save your program asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.

In this program, complete the following mathematical actions, in the following order:

Round VAR1 and VAR2 to the nearest integer values.

Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3.

Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.

For observation 16, what is the value ofVAR20? Enter your numeric answer in the space below. Round your answer to the nearest whole number. Save your program asprogram04.sasincert\programs before continuing with the next project

Show Answer Hide Answer
Correct Answer: A

SAS code that could be used to solve this project:

data results.output04;

set cert.input04;

var3=round(var1,1)*round(var2,1);

var20=sum(of var12-var19);

run;

proc print data=results.output04 (obs=16 firstobs=16);

var var3 var20;

run;

If you got this question wrong because you didn't round to the nearest whole number, please know that the actual exam will restrict you to entering only a whole number to prevent this from occurring. The correct answer is: 3175