A00-212 Online Practice Questions and Answers

The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.

proc sort data=WORK.CHECK;

by Code;

run;

What describes the result of submitting SAS program?

A. The index on Code is updates

B. The sort does not execute

C. The index on Code is deleted

D. The index on the Code unaffected

Which one of the following techniques concatenates data in SAS?

A. the APPEND procedure

B. the DATA step with a MERGE statement

C. the DATA step with a COMBINE statement

D. the INTERSECT operator in the SQL procedure

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

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

Given the data set SASHELP.CLASS:

SASHELP.CLASS

NAME AGE

Mary 15

Philip 16

Robert 12

Ronald 15

The following SAS program is submitted:

%let value = Philip;

proc print data = sashelp.class;

run;

Which WHERE statement successfully completes the program and procedures a report?

A. Where upcase(name)=%upcase(andvalue);

B. Where upcase(name)="upcase(andvalue)";

C. Where upcase(name)=upcase(andvalue);

D. Where upcase(name)="%upcase(andvalue)";

The following SAS program is submitted:

%let first = yourname;

%let last = first;

%put andandandlast;

Which one of the following is the result in the log of the %PUT statement?

A. first

B. andfirst

C. yourname

D. andyourname

Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes that text to the log?

A. MPRINT

B. MLOGIC

C. MSOURCE

D. SOURCE2

The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and The following SAS program is submitted:

Proc format cntlin=wor.tempdata;

Run;

What is the result of submitting the FORMAT procedure step?

A. It uses the WORK.TEMPDATA SAS data set as input to create the format

B. All formats created will be stored in two WORK.TEMPDATA SAS data set

C. An ERROR message is written to the SAS log because the program is incomplete

D. NO formats are created in this step