The SAS data set TEMP has the following distribution of values for variable A: A Frequency

1 500,000

2 500,000

6 7,000,000

8 3,000

Which one of the following SAS programs requires the least CPU time to be processed?

A. data new; set temp; if a = 8 then b = 'Small '; else if a in(1, 2) then b = 'Medium'; else if a = 6 then b = 'Large'; run;

B. data new; set temp; if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small'; else if a = 6 then b = 'Large'; run;

C. data new; set temp; if a = 6 then b = 'Large '; else if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small';

D. data new; set temp; if a = 6 then b = 'Large '; if a in (1, 2) then b = 'Small'; run;

The following SAS program is submitted:

proc contents data = testdata.one;

run;

Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

A. proc sql; show testdata.one; quit;

B. proc sql; describe testdata.one; quit;

C. proc sql; show table testdata.one; quit;

D. proc sql; describe table testdata.one; quit;

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

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:

data temp;

array points{3,2}_temporary_ (10,20,30,40,50,60);

score = points{2,1}

run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

A. 10

B. 20

C. 30

D. 40