A00-231 Exam Training Practice Tests (SASInstitute SAS 9.4 Base Programming

Question 1

Given the following SAS log entry:

What caused the error?

A. The CANCEL option is required with DATALINES. B. Character data must be specified in quotes. C. The INPUT statement should be after the DATALINES statement. D. A semi-colon is missing on the DATALINES statement.

Correct Answer: D

Question 2

The following SAS program is submitted:
Data_null_;
set old;
put sales 1 sales2;
run;
Where is the output written?

A. to the raw data file that was most recently opened B. to the SAS data set _NULL_ C. to the SAS output window or to an output file D. to the SAS log

Correct Answer: D

Question 3

Given the SAS data set EMPLOYEES:
EMPLOYEES
NAME SALARY
-------- ------------
Innis60000
Jolli50000
Ellis55000
Liu45000
The following SAS program is submitted:
proc print data = employees; where name like '_i%';
run;
What is contained in the output?

A. Liu only B. Innis, Jolli, Ellis, and Liu C. Innis and Ellis only D. Innis, Ellis, and Liu only

Correct Answer: A

Question 4

What is the purpose or the MISSOVER option on the INFILE statement?

A. It prevents SAS from loading a new record when the end of the current record is reached. B. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement. C. It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement. D. It enables SAS to scan the input data records until the character string that is specified in the @'character-string' expression is round.

Correct Answer: A

Question 5

Given the SAS data set WORK.ONE:

And the SAS data set WORK.TWO:

The following program is submitted:

What is the first observation in the SAS data set WORK.BOTH?

A. Option D B. Option B C. Option A D. Option C

Correct Answer: D

Question 6

The SAS data set EMPLOYEE_INFO is listed below:
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12
The following SAS program is submitted:
proc sort data = employee_info;
run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

A. by IDNumber descending Expenses descending; B. by descending IDNumber descending Expenses; C. by (IDNumber Expenses) descending; D. by descending IDNumber Expenses;

Correct Answer: B

Question 7

The following SAS program is submitted:
data allobs;
set sasdata.origin (firstobs = 75 obs = 499);
run;
The SAS data set SASDATA.ORIGIN contains 1000 observations.
How many observations does the ALLOBS data set contain?

A. 425 B. 1000 C. 499 D. 424

Correct Answer: A

Question 8

The following SAS program is submitted:
data one;
addressl = '214 London Way';
run;
data one;
set one;
address = tranwrd(address1, 'Way', 'Drive'); run;
What are the length and value of the variable ADDRESS?

A. Length is 200; value is '214 London Drive'. B. Length is 14; value is '214 London Dri'. C. Length is 14; value is '214 London Way'. D. Length is 16; value is '214 London Drive'.

Correct Answer: A

Question 9

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:
* Combine data sets cert.input08a and cert.input08b by matching values of the ID variable.
* Write only observations that are in both data sets to a new data set named results.match08.
* Write all other non-matching observations from either data set to a new data set named results.nomatch08.
* 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.

Correct Answer:

5
Explanation:
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 10

The following SAS program is submitted:
data work.retail;
cost = '20000';
total= .10* cost
run;
What is the result?

A. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log. B. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error. C. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log. D. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.

Correct Answer: C

Question 11

The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?

A. ods file = 'sales.html'; ods file close; B. ods html = 'sales.html'; ods html close; C. ods html file = 'sales.html'; ods html close; D. ods file html = 'sales.html'; ods file close;

Correct Answer: C

SASInstitute SAS 9.4 Base Programming - Performance-based - A00-231 Exam Practice Test