SAS Institute A00-211 - SAS Base Programming for SAS 9 Exam
Page: 3 / 54
Total 270 questions
Question #11 (Topic: Volume A)
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?
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 SORT procedures contain invalid syntax.
B. The merged data sets are not permanent SAS data sets.
C. The RUN statement was omitted alter each or the SORT procedures.
D. The data sets were not merged in the order by which they were sorted.
Answer: D
Question #12 (Topic: Volume A)
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
A. 0
B. 1
C. 5
D. 60
Answer: D
Question #13 (Topic: Volume A)
Given the following raw data record:
----I----10---I----20---I----30
son Travis,
The following output is desired:
Obs relation firstname
1 son Travis
Which SAS program correctly reads in the raw data?
----I----10---I----20---I----30
son Travis,
The following output is desired:
Obs relation firstname
1 son Travis
Which SAS program correctly reads in the raw data?
A. data family ( dIm = ‘,’); infile ‘tile specification’; input relation $ firstname $; run;
B. options dIm = ‘,’; data family; infile ‘file specification’; input relation $ firstname $; run;
C. data family; infile ‘file specification’ dIm = ‘,’; input relation $ firstname $; run;
D. data family; infile ‘file specification’; input relation $ firstname $ / dim = ‘,’; run;
Answer: C
Question #14 (Topic: Volume A)
Given the SAS data set AGES:
AGES
AGE
---------
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
AGES
AGE
---------
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
A. 0
B. 1
C. 2
D. 3
Answer: A
Question #15 (Topic: Volume A)
Given the SAS data set PRICES:
PRICES
prodid price
K12S 5.10 producttype
NETWORK sales
15 returns
B132S 2.34 HARDWARE 300 10
R18KY21.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = HARDWARE then output HWARE;
else if producttype = NETWORK then output INTER;
else if producttype = SOFTWARE then output SOFT;
run;
How many observations does the HWARE data set contain?
PRICES
prodid price
K12S 5.10 producttype
NETWORK sales
15 returns
B132S 2.34 HARDWARE 300 10
R18KY21.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = HARDWARE then output HWARE;
else if producttype = NETWORK then output INTER;
else if producttype = SOFTWARE then output SOFT;
run;
How many observations does the HWARE data set contain?
A. 0
B. 2
C. 3
D. 4
Answer: B
