QUESTION: 45

Which of the following is true about the COMPRESS=YES data set option?

It is most effective with numeric data that represents large numeric values
It is most effective with character data that contains patterns, rather than simple repetitions
It uses the Ross Data Compression method to compress numeric data
It is most effective with character data that contains repeated characters

Answer(s): D

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

Reveal Solution 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

Reveal Solution 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

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 12)

QUESTION: 45

QUESTION: 46

QUESTION: 47

QUESTION: 48