SAS 9.4 Base Programming - Performance-based exam (A00-231) Free Practice Test

Question 1

The following SAS DATA step is submitted:
data sasdata.atlanta
sasdata.boston
work.portland
work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?

A. The data sets listed in the last two IF statements require a library reference.

B. No library references are required.

C. The data sets listed on all the IF statements require a library reference.

D. The data sets listed in the first two IF statements require a library reference.

Correct Answer: D

Question 2

Which statement about SAS libraries is true? Select one:

A. You refer to a SAS library by a logical name called a lib name.

B. At the end of each session, SAS deletes the contents of all SAS libraries.

C. A SAS library is a collection of one or more SAS files that are referenced and stored as a unit.

D. A single SAS library must contain files that are stored in different physical locations.

Correct Answer: C

Question 3

The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?

A. the character value "01011960"

B. the numeric value 0

C. the step will not compile because of the character argument in the mdy function.

D. a missing value due to syntax errors

Correct Answer: B

Question 4

Given the SAS data set QTR 1_REVENUE:
destination revenue
YYZ53634
FRA62129
FRA75962
RDU76254
YYZ82174
The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue; run;
What is the first observation in the output data set?

A. destination revenue FRA 75962

B. destination revenue YYZ 82174

C. destination revenue FRA 62129

D. destination revenue YYZ 53634

Correct Answer: A

Question 5

Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

A. data employees; infile 'file specification'DLM dsd; input employee $ bdata mmddyy10.years; run;

B. data employees; infile 'file specification'dsd='*'; input employee $ bdata mmddyy10.years; run;

C. data employees; infile 'file specification'dlm='*'; input employee $ bdata: mmddyy10.years; run;

D. data employees; infile 'file specification' dLM='*' dsd; input employee $ bdata: mmddyy10.years; run;

Correct Answer: D

Question 6

The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?

A. The variable Code is sorted by ascending order.

B. The PSORT data set is stored in the SASUSER library.

C. The descending option applies to the variable Code.

D. The descending option applies to the Date and Cost variables.

Correct Answer: A

Question 7

Scenario:
This project will use data set cert.input12. At any time, you may
save your program as program12 in cert\programs.
cert.input12 contains a single observation with two variables:
* salary
* year
Write a SAS program that will:
* Create an output data set results.output12.
* Read cert.input12 as input.
* Increase the salary variable by 5.65% annually until it is
greater than $500,000.
* Increment the year variable by 1 with each annual
increase.
* Create an output data set results.output12 that has one
observation for each value of year. Each observation
should have a year and salary variable.
What is the value of year when the above salary occurs? Enter your numeric answer in the space below.

Correct Answer:

2027
Explanation:
data results.output12;
set cert.input12;
do until (salary gt 500000);
salary=salary*1.0565;
year+1;
output;
end;
run;
proc print data=results.output 12;
run;

Question 8

The following SAS program is submitted:

The program fails execution due to syntax errors.
What is the cause of the syntax error?

A. An array cannot be referenced on a KEEP data set option.

B. The KEEP= data set option should be the statement KEEP MONTHSALES{12}.

C. The KEEP= data set option should be (KEEP = MONTHSALES).

D. The variable MONTHSALES does not exist.

Correct Answer: A

Question 9

The following SAS program is submitted:
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;
What is the value of the CITY variable?

A. ''(missing character value)

B. Copenh

C. Other

D. Copenhagen

Correct Answer: C

Question 10

Given the raw data record in the file phone.txt:

Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?

A. FullName=EmpFName!!EmpLName;

B. FullName=EmpFName + EmpLName;

C. FullName=CATX('',EmpFName,EmpLName);

D. FullName=CAT('',EmpFName,EmpLName);

Correct Answer: C

Question 11

Given the SAS data set WORK.ONE:

What value will SAS assign to Total?

A. 3

B. The program fails to execute due to errors.

C. 1.6

D. 4.8

Correct Answer: C

Welcome to TestSimulate

SASInstitute SAS 9.4 Base Programming - Performance-based (A00-231) Free Practice Test