Real IT Certification Exams Questions & Dumps | Get Certified with CertQuestionsBank.com

Latest A00-231 Exam Practice Questions

The practice questions for A00-231 exam was last updated on 2025-06-03 .

Viewing page 1 out of 2 pages.

Viewing questions 1 out of 13 questions.

Question#1

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?

A. CLASS

B. ID

C. IDLABEL

D. VAR

Question#2

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.match08

A. 117

Explanation:
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;
SAS code that could be used to solve this project:
proc
sort data=cert.input08a out=work.input08a;
by ID;
run:
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 117

Question#3

Variable Name would have a format of $CHAR15. in the new data set Work. Both. The LENGTH statement only gives the variable Name a predefined maximum length.
The correct answer is:
$CHAR15 Given the SAS data set WORK.ONE:
X Y Z
- - --
1A27
1A33
1B45
2A52
2B69
3B70
4A82
4C91
The following SAS program is submitted: data WORK.TWO;
set WORK.ONE; by X Y;
if First.Y; run; proc print data=WORK.TWO noobs; run;
Which report is produced? Select one:
A.XYZ
-- -- --
1B45
2A52
2B69
3B70
4A82
4C91
B.XYZ
-- -- --
1A27
1B45
2A52
2B69
3B70
4A82
4C91
C.XYZ
-- -- --
1A33
1B45
2A52
2B69
3B70
4A82
4C91
D.XYZ
-- -- --
1A27
1B45
2A52
2B69
4A82
4C91

A. B

Question#4

SIMULATION
Scenario:
This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs.
Write a SAS program that will clean the data incert.input36as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
Create results.output36 from cleandata36
Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respective group (A, B) calculated in step 2
What is the MEAN Kilograms value for group='A' in the results.output36 data set?

A. 76.3

Explanation:

Question#5

The variable Name in the data set Employeehas a $CHAR10. format. The variable Name in the data set Sales has a $CHAR15. format.
The following SAS program is submitted: data both;
length name $ 20;
merge sales employee;
by id;
run;
What is the format for the variable Name in the data set Both?
Select one:

A. $20

B. $CHAR10

C. $CHAR15

D. $CHAR20

Exam Code: A00-231Q & A: 36 Q&AsUpdated: 2025-06-03

Get All A00-231 Q&As

A00-231 Online Practice Questions

Question#1

Question#2

Question#3

Question#4

Question#5

Top 20 Exams

Important Links

Know Us

Follow Us