SASInstitute A00-202 Actual Free Exam Questions & Community Discussion
Which one of the following statements is true regarding a SAS DATA step view?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
%let a = cat;
%macro animal(a = frog);
%let a = bird; %mend; %animal(a = pig) %put a is &a; Which one of the following is written to the SAS log?
%let a = cat;
%macro animal(a = frog);
%let a = bird; %mend; %animal(a = pig) %put a is &a; Which one of the following is written to the SAS log?
Correct Answer: C
Vote an answer
Given the following SAS data set ONE:
ONE CATEGORY AGE SALARY BONUS
M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10
F 35 400 50
The following SAS program is submitted:
proc sql;
select distinct category,
sum(sum(salary,bonus)) as EARNINGS
from one
where age < 30
group by category
having calculated EARNINGS < 500;
quit;
Which one of the following reports will be generated?
ONE CATEGORY AGE SALARY BONUS
M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10
F 35 400 50
The following SAS program is submitted:
proc sql;
select distinct category,
sum(sum(salary,bonus)) as EARNINGS
from one
where age < 30
group by category
having calculated EARNINGS < 500;
quit;
Which one of the following reports will be generated?
Correct Answer: A
Vote an answer
Which one of the following statements about compressed SAS data sets is always true?
Correct Answer: C
Vote an answer
The following SAS program is submitted.
filename sales ('external-file1' 'external-file2');
data new;
infile sales;
input date date9. company $ revenue; run;
Which one of the following is the result of including the FILENAME statement in this program?
filename sales ('external-file1' 'external-file2');
data new;
infile sales;
input date date9. company $ revenue; run;
Which one of the following is the result of including the FILENAME statement in this program?
Correct Answer: A
Vote an answer
The variable attributes of SAS data sets ONE and TWO are shown below:
ONE TWO # Variable Type Len Pos # Variable Type Len Pos 2 sales Num 8 8 2 budget Num 8 8 1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0
Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.
The following SAS program is submitted:
data three; merge one two; by year;
run;
Which one of the following is the result of the program execution?
ONE TWO # Variable Type Len Pos # Variable Type Len Pos 2 sales Num 8 8 2 budget Num 8 8 1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0
Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.
The following SAS program is submitted:
data three; merge one two; by year;
run;
Which one of the following is the result of the program execution?
Correct Answer: A
Vote an answer
Given the following SAS data set named WORK.INTERNAT:
WORK.INTERNAT LOCATION SUM
USA 30 EUR 40
The following SAS program is submitted:
%let LOC = Usa;
proc sql;
select *
from internat
where location = "&Loc"; quit;
Which one of the following is the result when the above code is executed on the above data set?
WORK.INTERNAT LOCATION SUM
USA 30 EUR 40
The following SAS program is submitted:
%let LOC = Usa;
proc sql;
select *
from internat
where location = "&Loc"; quit;
Which one of the following is the result when the above code is executed on the above data set?
Correct Answer: A
Vote an answer
Given the following SAS data sets ONE and TWO:
ONE TWO NUM CHAR1 NUM CHAR2
1 A 2 X 2 B 3 Y 4 D 5 V
The following SAS program is submitted creating the output table THREE:
data three; set one two; run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V
Which one of the following SQL programs creates an equivalent SAS data set THREE?
ONE TWO NUM CHAR1 NUM CHAR2
1 A 2 X 2 B 3 Y 4 D 5 V
The following SAS program is submitted creating the output table THREE:
data three; set one two; run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V
Which one of the following SQL programs creates an equivalent SAS data set THREE?
Correct Answer: A
Vote an answer
0
0
0
10