Free A00-202 Exam Dumps Preview

Given the following SAS data set ONE:

ONE
REP AREA COST
------------------------------------
SMITH NORTH 100
SMITH SOUTH 200
JONES EAST 100
SMITH NORTH 300
JONES WEST 100
JONES NORTH 200

JONES NORTH 400
SMITH NORTH 400
JONES WEST 100
JONES WEST 300

The following SAS program is submitted:
proc sql;
select rep, area, count(*) as TOTAL
from one group by rep, area;
quit;

Which one of the following reports is generated?

Given the following SAS data set ONE:

ONE
LEVEL AGE
--------------------
1 10
2 20
3 20
2 10
1 10

2 30
3 10
2 20
3 30
1 10

The following SAS program is submitted:
proc sql;
select level, max(age) as MAX from one group by level
having max(age) > (select avg(age) from one);
quit;

Which one of the following reports is generated?

The following SAS program is submitted:
data temp;
array points{3,2}_temporary_ (10,20,30,40,50,60); score = points{2,1}
run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

Which one of the following is the purpose of the IDXNAME= data set option?

Which one of the following statements is true?

Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

The following SAS program is submitted:

%let value = 9;
%let value2 = 5;
%let newval = %eval(&value / &value2);

Which one of the following is the resulting value of the macro variable NEWVAL?

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?

Given the following SAS data sets ONE and TWO:

ONE TWO
OBS COMMON X OBS COMMON Y
-------------------------- ------------------------------ 1 A 10 1 A 1
2 A 13 2 A 3
3 A 14 3 B 4
4 B 9 4 B 2
5 C 8 5 C 5
6 C 14

The following SAS DATA step is submitted: data combine; set one; set two; run;

Which one of the following represents the data values stored in data set COMBINE?

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;

The SAS data set TEMP contains 2,500,000 observations.

Which one of the following represents the possible values for PTOBS?

Given the following SAS data set ONE:

ONE
REP COST
------------------------

SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
JONES 200
JONES 400
SMITH 800
JONES 100
JONES 300

The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE from one group by rep
having avg(cost) > (select avg(cost) from one);
quit;

Which one of the following reports is generated?

The following SAS ARRAY statement is submitted:
array score{*} a4 - a10, a25 ;

Which one of the following is the maximum number of elements stored?

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?

Given the following SAS data sets ONE and TWO:

ONE TWO
YEAR QTR BUDGET YEAR QTR SALES
------------------------------- -------------------------------- 2001 3 500 2001 4 300
2001 4 400 2002 1 600
2002 1 700

The following SAS program is submitted:
proc sql;

select one.*, sales
from one, two;
quit;

Which one of the following reports is generated?

Given the following SAS data set ONE:

ONE
LEVEL AGE
----------------------
1 10
2 20
3 20
2 10
1 10
2 30
3 10
2 20
3 30
1 10

The following SAS program is submitted:
proc sql;
select level, max(age) as MAX from one group by level
having max(age) > (select avg(age) from one);
quit;

Which one of the following reports is generated?

Given the following SAS data set ONE:

ONE
JOB LEVEL SALARY
------------------------------------------
ACC 2 300
SEC 1 100
SEC 2 200
MGR 3 700
ACC 1 .
ACC 3 .
MGR 2 400

The following SAS data set TWO is created:

TWO
JOB LEVEL BONUS
-------------------------------------
ACC 2 30
MGR 3 70
MGR 2 40

Which one of the following SAS programs creates data set TWO?

When is it appropriate to create indexes on a SAS data set for efficient processing?

The following SAS FORMAT procedure is submitted:
proc format lib = sasuser;
value tempc low < 0 = 'BELOW FREEZING'
0 < 5 = 'COLD'

5 < 10 = 'MILD'
10 < 15 = 'WARM'
15 high = 'HOT';
run;

How is the value 10 displayed when the format TEMPC is applied?

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?