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

The following SAS program is submitted:

The current system date macro variable is 30JUL2013. Which output will be written to the log by the program?

A. In two years it will be: 2014+1

B. Error: Required operator not found in expression in two years it will be: 2013+12+1

C. In two years it will be: 2013+1+1+1

D. In two years it will be: 2014+1+1

Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

A. OBS=pointobs

B. POINT=pointobs

C. KEY=pointobs

D. NOBS=pointobs

Given a SAS data set with the following characteristics:

200 million observations 300 variables Compressed Resides on a network location

A SAS DATA Step program is written that will retrieve 20% of the data using a search based on a range of a character variable.

Which type of statement is the best choice to minimize computer resource utilization when subsetting this data?

A. KEEP/DROP

B. WHERE

C. CASE

D. IF/THEN/ELSE

This question will ask you to provide a segment of missing code.

Given the following program and data:

What is the WHERE statement that successfully completes the PROC PRINT and selects the observation from Barb?

A. Where Birthday=and"Want";

B. Where Birthday=and`Want' d;

C. Birthday=andWant;

D. Birthday=and"Want" d;

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?

A. REP AVERAGE JONES 200

B. REP AVERAGE JONES 320

C. REP AVERAGE SMITH 320

D. REP AVERAGE SMITH 500

Given the SAS data set WORK TRANSACT:

The following output is desired:

Which SQL statement was used?

A. Option A

B. Option B

C. Option C

D. Option D

The following SAS program is submitted:

date view=sauser.ranch;

describe;

run;

What is the result?

A. The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor window

B. The program retrieves the SAS source code that creates the view and places it in the output window

C. The program creates a DATA step view called SASUSER.RANCH and places it in the SAS log

D. the program retrieves the SAS source code that creates the view and places it in the SAS log

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

Which one of the following options controls the pagesize of a SAS data set?

A. SIZE=

B. BUFNO=

C. BUFSIZE=

D. PAGESIZE=