SAS Base Programming for SAS 9 (A00-211) Free Practice Test

Question 1

Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

The following SAS program is submitted:
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
Which output is correct?

Correct Answer:

Pending

Question 2

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 3

A raw data file is listed below:
--------10-------20-------30
squash 1.10
apples 2.25
juice 1.69
The following SAS program is submitted using the raw data file above:
data groceries;
infile 'file-specification';
input item $ cost;
run;
Which one of the following completes the program and produces a grand total for all COST values?

A. retain grandtot 0;grandtot = sum(grandtot,cost);

B. grandtot = sum(grandtot,cost);

C. grandtot = sum(grandtot,cost);output grandtot

D. grandtot = sum cost;

Correct Answer: A

Question 4

The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?

A. the descriptor portion of the data set SASUSER.AIRPLANES only

B. the data portion of every data set in the SASUSER library

C. the descriptor portion of every data set in the SASUSER library

D. the data portion of the data set SASUSER.AIRPLANES only

Correct Answer: A

Question 5

The following SAS program is submitted:
data work.month;
date = input('13mar2000',date9.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?

A. numeric, 8 bytes

B. character, 9 bytes

C. character, 8 bytes

D. numeric, 9 bytes

Correct Answer: A

Question 6

Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

A. WINXP

B. CSVALL

C. MSOFFICE2K

D. EXCELXP

Correct Answer: A

Question 7

A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH';
input sqfeet bedrooms baths street $ price : dollar10.;
run;
How many observations will the output data set contain?

A. 3

B. 7

C. 0

D. 5

Correct Answer: A

Question 8

The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:
WORK.ONE
Num Char
------ ------
1 23
3 23
1 77
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num='1';
run;
What is output?

A. Num Char--- ----1 23

B. No output is generated.

C. Num Char--- ----1 231 77

D. Num Char--- ----1 233 231 77

Correct Answer: B

Question 9

The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price". Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?

A. proc print data = sasuser.houses label; label price = "Sale Price"; run;

B. proc print data = sasuser.houses; label price = "Sale Price"; run;

C. proc print data = sasuser.houses label; label price "Sale Price"; run;

D. proc print data = sasuser.houses; price = "Sale Price"; run;

Correct Answer: A

Question 10

The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?

A. The RUN statement was omitted alter each or the SORT procedures.

B. The SORT procedures contain invalid syntax.

C. The merged data sets are not permanent SAS data sets.

D. The data sets were not merged in the order by which they were sorted.

Correct Answer: D

Question 11

The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?

A. proc print data=MYXLS.NORTH$;run;

B. proc print data=MYXLS.NORTH;run;

C. proc print data=MYXLS.'NORTH$'n;run;

D. proc print data=MYXLS.'NORTH'e;run;

Correct Answer: C

Question 12

The following SAS program is submitted:

What will the data set WORK.TEST contain?

A. Option D

B. Option C

C. Option A

D. Option B

Correct Answer: C

Question 13

The following SAS program is submitted:

What is the result?

A. The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.

B. The value of the variable Discount in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

C. The variable Discount in the output data set is set to zero. No messages are written to the SAS log.

D. The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.

Correct Answer: D

Question 14

The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:

What is the length of the Name variable in the data set WORK STAFF_UPDATE?

A. 8

B. 15

C. 20

D. 10

Correct Answer: D

Welcome to TestSimulate

SASInstitute SAS Base Programming for SAS 9 (A00-211) Free Practice Test