SAS A00-231 Exam Practice Test Instant Access

Question 1

Assume thatWork.Ds1andWork.Ds2exist and the following SAS program is submitted:

How many PDF files are created? Select one:

A1 PDF file with all the output combined

B2 PDF files -- one file for each data set used

C2 PDF files -- one for the PRINT output and one for the FREQ output

D3 PDF files -- one per procedure request

Answer : A

Question 2

SIMULATION

Scenario:

Continuing with the previous program (program27), add a PROC SORT step that satisfies the following criteria:

o Creates the output dataset results.output27b

o Sorts the observations by order.

o Removes duplicate values of the first occurrence found during the sort.

What is the value of Employee_ID for observation 98 inresults.output27b?

A120779

Answer : A

proc sort data=cert.input27 out=results.output27b nodupkey;

by descending postal_code;

run;

proc print data=results.output27b (firstobs=98 obs=181);

var employee_ID;

run:

Question 3

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 respectivegroup(A,B) calculated in step 2

How many observations are inresults.output36?

A4992

Answer : A

data work.cleandata36;

set cert.input36;

group=upcase(group);

if group in ('A','B');

run;

proc means data=work.cleandata36 median;

class group;

var kilograms;

run;

data results.output36;

set cleandata36;

if Kilograms < 40 or Kilograms > 200 then do;

if group='A' then kilograms=79; else kilograms=89;

end;

run;

proc contents data=results.output36;

run;

Question 4

SIMULATION

Scenario:

This project will use data set cert.input13. At any time, you may

save your program as program13 in cert\programs.

This data set contains 1001 observations and 2 variables:

o Date1, a numeric variable representing an unformatted

SAS date value. Example: 12001.

o Charnum, a character variable representing a monetary

amount. Example: $50,000.

Write a SAS program that will:

o Save the new data set as results.output13.

o Create a new variable Chdate that converts

the datel variable to a character variable that is in the

format ddmonyyyy, such as 11NOV1992.

o Create a new variable num1 that converts

the Charnum variable to a numeric variable.

What is the average (mean) of the num1 variable for the entire data set?

Enter your numeric answer in the space below (Round your answer to the nearest

integer).

A51763

Answer : A

data results.output13;

set cert.input13;

Chdate=put(date 1,date9.);

num 1=input(Charnum,dollar7.);

run;

proc means data=results.output13;

var num 1;

run;

Question 5

SIMULATION

Scenario:

Continuing with the previous program (program27), add a PROC SORT step that satisfies the following criteria:

o Creates the output dataset results.output27b

o Sorts the observations by order.

o Removes duplicate values of the first occurrence found during the sort.

What is the value of Employee_ID for observation 181 inresults.output27b?

A120272

Answer : A

proc sort data=cert.input27 out=results.output27b nodupkey;

by descending postal_code;

run;

proc print data=results.output27b (firstobs=98 obs=181);

var employee_ID;

run:

Question 6

A PROC PRINT report was created with the following title:

Asia Sports Vehicle Summary After the PROC PRINT report is run, a programmer would next like to produce a PROC FREQ report with the following title: Asia Sports Vehicle Summary Distribution by Make Which statement(s) would produce the new report titles?

Select one:

Atitle 'Distribution by Make';

Btitle 'Asia Sports Vehicle Summary'; title 'Distribution by Make';

Ctitle 'Asia Sports Vehicle Summary'; title2 'Distribution by Make';

Dtitle 'Asia Sports Vehicle Summary'; subtitle 'Distribution by Make';

Answer : C

Question 7

SIMULATION

Scenario:

This project will use data set cert.input27. At any time, you may

save your program as program27 in cert\programs. You will use

this program in the next project.

Write a SAS program that will:

o Create output data set results.output27a as a subset

of cert.input27 where the country variable's value is

"US" (any variation of case, such as US or us).

o Sort results.output27a:

" first by the variable state in ascending order

" then by Postal_Code in descending order

" and finally by employee_ID in ascending order.

Run the program and use the results to answer the question below.

What is the value of Employee_ID for observation 100 in results.output27a?

A120781

Answer : A

proc sort data=cert.input27

out=results.output27a(where=(upcase (country)='US'));

by state descending Postal_Code employee_ID;

run;

proc print data=results.output27a (firstobs=100 obs=100);

var employee_ID;

run:

SAS A00-231 SAS 9.4 Base Programming - Performance-Based Exam Practice Test