Geekcert New Updated A00-202 Exam Dumps Free Download

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


Leave a Reply

Your email address will not be published.