Free A00-212 Exam braindumps download (A00-212 exam dumps Free)

QUESTION: 46

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?

It names the variable NEXTFILE, whose value is output to the SAS data set NEW
It names the variable NEXTFILE, whose values point to an aggregate storage location
It names the variable NEXTFILE, whose value is a SAS file reference
It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file

Answer(s): D

Show Answer Next Question

QUESTION: 47

The following SAS program is submitted:

%micro cols1;
name age;
%mend;
%macro cols2;
height weight
%mend
proc print data=sashelp.class;
<insert VAR statement here>
Run

Which VAR statement successfully completes the program and produces a report?

var heigh %cols1;
var %cols1 %cols2 height;
var %cols1 height;
var %cols2 %cols1;

Answer(s): A

Show Answer Next Question

QUESTION: 48

The following SAS program is submitted:

data new(bufsize = 6144 bufno = 4);
set old;
run;

What is the difference between the usage of BUFFSIZE= and BUFNO= options?

BUFSIZE=specifies the size of the output buffer in kilobytes; BUFNO=specifies the number of output buffers
BUFSIZE= specifies the size of the input buffer in bytes; BUFFNO= specifies the number of input buffers
BUFSIZE= specifies the size of the input buffer in kilobytes; BUFNO=specifies the number of input buffers
BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers

Answer(s): D

Show Answer Next Question

QUESTION: 49

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?