Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
A00-212 Examination questions (September)

Achieve New Updated (September) SAS A00-212 Examination questions 31-40

September 25, 2015

Ensurepass

QUESTION 31

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

 

A.

MODIFY and CHANGE statements

B.

RENAME statement only

C.

CHANGE statement only

D.

MODIFY and RENAME statements

 

Answer: C

 

 

QUESTION 32

 

The following SAS program is submitted:

 

%macro loop;

 

data one;

 

%do I=1 %to 3;

 

var&I=&I;%

 

end

 

run;

 

%mend;

 

%loop

 

After this program executes; the following is written to the SAS log:

 

(LOOP): Beginning execution

 

(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is (LOOP): %DO loop index variable l is now 2; loop will iterate again

 

(LOOP): %DO loop index variable l is no 3; loop will iterate again

 

(LOOP): %DO loop index variable l is no 4; loop will iterate again

 

(LOOP): Ending execution

 

Which SAS system option displays the notes in the SAS log?

 

A.

SYMBOLGEN

B.

MLOGIC

C.

MACRO

D.

MPRINT

 

Answer: B

 

 

QUESTION 33

 

Given the SAS date sets CLASS1 and CLASS2

 

CLASS1 CLASS2

 

NAME COURSE NAME COURSE

 

Lauren MATH1 Smith MATH2

 

Patel MATH1 Farmer MATH2

 

Chang MATH1 Patel MATH2

 

Chang MATH3 Hiller MATH2

 

The following SAS program is submitted:

 

Proc sql;

 

Select name from CLASS1

 

<insert SQL set operator here>

 

select name from CLASS;

 

quit;

 

The following output is desired

 

NAME

 

Chang

 

Chang

 

Lauren

 

Which SQL set operator completes the program and generates the desired output?

 

A.

UNION ALL

B.

EXCEPT ALL

C.

INTERSECT ALL

D.

OUTER UNION ALL

 

Answer: B

 

 

QUESTION 34

 

The following SAS program is submitted:

 

data temp;

 

set sasuser.history(kep=date);

 

format date qtr

 

<insert BY statement here>

 

if first.date then total=0;

 

total+1;

 

if last.date;

 

run;

 

proc print data=temp;

 

run

 

SASUSER.HISTORY is sorted by the SAS date variable DATE.

 

The following output is required:

 

Date Total

 

1 13

 

3 15

 

4 25

 

Which By statement completes the data step and successfully generates the required output?

 

A.

by groupformat date;

B.

by formateed date;

C.

by notsorted date;

D.

by date qtr

 

Answer: A

 

 

 

QUESTION 35

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

 

Answer: CD

 

 

QUESTION 36

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

 

Answer: A

 

 

QUESTION 37

Given the following partial SAS log:

 

 

 

 

NOTE: SQL table SASHELP.CLASS was created line

 

Create table SASHELP.CLASS(bufsize=4096)

 

(

 

Name char(8);

 

Gender Char(1);

 

Age num;

 

Height num;

 

Weight num

 

);

 

Which SQL procedure statement generated this output?

 

A.

DESCRIBE TABLE

B.

LIST TABLE

C.

VALIDATE TABLE

D.

CREATE TABLE

 

Answer: A

 

 

QUESTION 38

The SAS data set ONE contains the variables X,Y,Z and W.

 

The following SAS program is submitted:

 

Proc transpose data =one

 

Out=trans

 

Name=new;

 

By x;

 

var y;

 

run;

 

 

 

 

What are the names of all of the columns created by the TRANSPOSE procedure?

 

A.

new, X,Y and _COL1_

B.

new, X and COL1 only

C.

new, Y and COL1 only

D.

new, X and Y only

 

Answer: B

 

 

QUESTION 39

The following SAS program is submitted:

 

data new;

 

do i=1,2,3

 

nextfile=compress(‘March’ || |);

 

infile abc filevar=nextfile

 

end=eof;

 

do until (eof);

 

input dept $sales;

 

end;

 

run;

 

What is the purpose of the FILEVAR=option on the INFILE statement?

 

A.

It names the variable NEXTFILE, whose value is output to the SAS data set NEW

B.

It names the variable NEXTFILE, whose values point to an aggregate storage location

C.

It names the variable NEXTFILE, whose value is a SAS file reference

D.

It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file

 

Answer: D

 

 

QUESTION 40

 

Given the following SAS data sets ONE and TWO:

 

ONE TWO

 

NUM CHAR1 NUM CHAR2

 

1 A1 2 X1

 

1 A2 2 X2

 

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 X2

 

2 B2 X1

 

2 B2 X2

 

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;

 

Answer: D

 

Free VCE & PDF File for SAS A00-212 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …