Geekcert is trying our best to keep on updating SAS Institute Systems Certification Latest A00-202 pdf exam dumps. We, Geekcert, will provide our customers with the latest and the most accurate exam questions and answers that cover every SAS Institute Systems Certification Jan 14,2022 Newest A00-202 vce dumps SAS advanced programming exam knowledge points, which will help you easily prepare yourself well for the Hotest A00-202 free download exam and successfully pass your exam. You just need to spend a few hours on studying the exam dumps.
Geekcert | A00-202 certification materials | videos | study guides. get A00-202 certification with Geekcert study materials and practice tests. Geekcert – 100% real A00-202 certification exam questions and answers. easily pass with a high score. latest microsoft, cisco, comptia,oracle,ibm,sun,juniper,hp and all A00-202 certification dumps – Geekcert.
We Geekcert has our own expert team. They selected and published the latest A00-202 preparation materials from SASInstitute Official Exam-Center: https://www.geekcert.com/A00-202.html
The following are the A00-202 free dumps. Go through and check the validity and accuracy of our A00-202 dumps.We have sample questions for A00-202 free dumps. You can download and check the real questions of updated A00-202 dumps.
Question 1:
The following SAS code is submitted:
%macro houses(dsn = houses,sub = RANCH);
data anddsn;
set sasuser.houses;
if style = “andsub”;
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)
Which one of the following is the value of the automatic macro variable SYSLAST?
A. work.ranch
B. work.houses
C. WORK.RANCH
D. WORK.HOUSES
Correct Answer: D
Question 2:
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?
A. YEAR QTR BUDGET SALES
2001 4 400 300
2002 1 700 600
B. YEAR QTR BUDGET SALES
2001 3 500 .
2001 4 400 300
2002 1 700 600
C. YEAR QTR BUDGET SALES
2001 3 500 300
2001 4 400 300
2002 1 700 600
D. YEAR QTR BUDGET SALES
2001 3 500 300
2001 4 400 300
2002 1 700 300
2001 3 500 600
2001 4 400 600
2002 1 700 600
Correct Answer: D
Question 3:
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
where one.year = two.year;
quit;
Which one of the following reports is generated?
A. YEAR QTR BUDGET SALES ——————————————————— 2001 4 400 300 2002 1 700 600
B. YEAR QTR BUDGET SALES ———————————————————- 2001 3 500 . 2001 4 400 300 2002 1 700 600
C. YEAR QTR BUDGET SALES ———————————————————— 2001 3 500 300 2001 4 400 300 2002 1 700 600
D. YEAR QTR BUDGET SALES ———————————————————— 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
Correct Answer: C
Question 4:
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?
A. REP AREA COUNT
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
B. REP AREA TOTAL
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
C. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
D. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
SMITH NORTH 3
SMITH SOUTH 1
Correct Answer: D
Question 5:
Given the following SAS data sets ONE and TWO:
ONE TWO NUM CHAR1 NUM CHAR 2
1 A1 2 X1
1 A2 2 X 2
2 B1 3 Y
2 B2 5 V
4 D
The following SAS program is submitted creating the output table THREE:
proc sql;
create table three as
select one.num, char1, char2
from one, two
where one.num = two.num;
quit;
THREE
NUM CHAR1 CHAR2
2 B1 X1 2 B1 X 2 2 B2 X 1 2 B2 X 2
Which one of the following DATA step programs creates an equivalent SAS data set THREE?
A. data three; merge one two; by num; run;
B. data three; set one; set two; by num; run; merge one two; by num; run;
C. data three; set one; set two; by num; run; by num; run;
D. data three; set one; do i = 1 to numobs; set two(rename = (num = num2)) point = i nobs = numobs; if num2 = num then output; end; drop num2; run;
Correct Answer: D
Question 6:
The following SAS program is submitted:
%macro execute;
proc print data = sasuser.houses;
run;
%end;
%mend;
Which of the following completes the above program so that it executes on Tuesday?
A. %if andsysday = Tuesday %then %do;
B. %if andsysday = \’Tuesday\’ %then %do;
C. %if “andsysday” = Tuesday %then %do;
D. %if \’andsysday\’ = \’Tuesday\’ %then %do;
Correct Answer: A
Question 7:
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?
A. CHECK
B. UNIQUE
C. FORMAT
D. DISTINCT
Correct Answer: A
Question 8:
The following SAS ARRAY statement is submitted: array score{*} a4 – a10, a25 ;
Which one of the following is the maximum number of elements stored?
A. 3
B. 7
C. 8
D. 11
Correct Answer: C
Question 9:
Which one of the following is true regarding the KEEP statement?
A. The KEEP statement is available in both the DATA and the PROC steps.
B. The KEEP statement selects the variables read from the input data set(s).
C. The KEEP statement applies to all data sets created within the same DATA step.
D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.
Correct Answer: C
Question 10:
The DICTIONARY.MACROS table stores information about which of the following?
A. user defined macro variables only
B. system defined macro variables only
C. both user and system defined macro variables
D. macros stored in the autocall macro library only
Correct Answer: C
Question 11:
The following SAS program is submitted:
proc sql;
select *
from dictionary.tables;
quit;
Which one of the following is reported?
A. metadata on all tables in all libraries
B. metadata on all tables in the WORK library only
C. metadata on all tables in the SASUSER library only
D. metadata on all tables in the DICTIONARY library only
Correct Answer: A
Question 12:
The following SAS program is submitted:
%macro test(var);
proc print data = sasuser.class;
where age > andvar;
run;
%mend;
Which type of parameter is the macro variable VAR?
A. default
B. keyword
C. positional
D. command
Correct Answer: C
Question 13:
Given the following SAS data sets ONE and TWO:
ONE TWO NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
The following SAS program is submitted:
proc sql;
select country from one where not exists
(select * from two where one.num = two.num);
quit;
Which one of the following reports is generated?
A. COUNTRY
GERMANY
JAPAN
B. COUNTRY
FRANCE
BELGIUM
C. COUNTRY
CANADA
FRANCE
BELGIUM
D. COUNTRY
CANADA
FRANCE
GERMANY
Correct Answer: C
Question 14:
The following SAS program is submitted:
%let value = .5;
%let add = 5;
%let newval = %eval(andvalue andadd);
Which one of the following is the resulting value of the macro variable NEWVAL?
A. 5
B. 5.5
C. .5 5
D. null
Correct Answer: D
Question 15:
Which one of the following options displays the value of a macro variable in the SAS log?
A. MACRO
B. SOURCE
C. SOURCE2
D. SYMBOLGEN
Correct Answer: D