SASInstitute SAS advanced programming - A00-202 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

The following SAS program is submitted:
proc datasets lib = testdata; modify one; label num = 'Number'; format num 4.;
quit;
Which one of the following SQL programs produces the same results as the above DATASETS procedure?

A. proc sql;
modify table testdata.one
alter num format = 4.
label = 'Number';
quit; B. proc sql;
alter table testdata.one
modify num (format = 4.
label = 'Number');
quit; C. proc sql;
modify table testdata.one
num format = 4.
label = 'Number';
quit; D. proc sql;
alter table testdata.one
modify num format = 4.
label = 'Number';
quit;

Discussion 0

Correct Answer: D Vote an answer

Question 2

Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
M 28 200 .
M 25 100 10
F 18 100 50
F 25 200 10
The following SAS program is submitted:
proc sql;
create table two as
select category, salary + bonus as EARNINGS from one; quit;
Which one of the following represents the data values stored in the data set TWO?

A. CATEGORY EARNINGS
M . M 110 F 150 F 210 B. CATEGORY SALARY BONUS EARNINGS
M 200 . . M 100 10 110 M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210 C. CATEGORY SALARY BONUS EARNINGS
M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210 D. CATEGORY EARNINGS
M 200 M 110 F 150 F 210

Discussion 0

Correct Answer: A Vote an answer

Question 3

The following SAS program is submitted: %let lib = %upcase(sasuser);
proc sql; select nvar from dictionary.tables where libname = "&lib";
quit;
Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

A. no result set B. a syntax error in the log C. a report showing the number of columns in each table in SASUSER D. a report showing the names of each table in SASUSER

Discussion 0

Correct Answer: C Vote an answer

Question 4

The SAS data set ONE consists of five million observations and has 25 variables.
Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?

A. data two;
set one;
totrev = sum(price * quantity);
where totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run; B. data two;
set one;
where totrev > 1000;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run; C. data two;
set one;
totrev = sum(price * quantity);
if totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run; D. data two;
set one;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
if totrev > 1000;
run;

Discussion 0

Correct Answer: C Vote an answer

Question 5

Given the following SAS program:
proc sql;
select product, type, sum(sales) as revenue
from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

A. order by product, desc revenue B. orderby product, revenue desc C. order by 1, 3 desc D. order by 1, 3

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which one of the following statements about compressed SAS data sets is always true?

A. An updated observation is stored in its original location. B. Each observation is treated as a single string of bytes. C. Each observation occupies the same number of bytes. D. New observations are added to the end of the SAS data set.

Discussion 0

Correct Answer: B Vote an answer

Question 7

The following SAS program is submitted:
%let name = Patel's Restaurant;
Which one of the following statements avoids problems associated with the unbalanced quotation mark?

A. %let name = %str(Patel%'s Restaurant); B. %let name = %str(Patel's Restaurant); C. %let name = Patel%'s Restaurant; D. %let name = Patel%str(')s Restaurant;

Discussion 0

Correct Answer: A Vote an answer

Question 8

The SAS data set TEMP has the following distribution of values for variable A:
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?

A. data new;
set temp;
if a = 6 then
b = 'Large ';
if a in (1, 2) then
b = 'Small';
run; B. data new;
set temp;
if a = 8 then
b = 'Small ';
else if a in(1, 2) then
b = 'Medium';
else if a = 6 then
b = 'Large';
run; C. data new;
set temp;
if a = 6 then
b = 'Large ';
else if a in (1, 2) then
b = 'Medium';
else if a = 8 then
b = 'Small'; D. data new;
set temp;
if a in (1, 2) then
b = 'Medium';
else if a = 8 then
b = 'Small';
else if a = 6 then
b = 'Large';
run;

Discussion 0

Correct Answer: C Vote an answer