A00-212 試験問題を無料オンラインアクセス

Which one of the following statements is true?

• A.The WHERE statement selects observations before they are brought into the PDV.
• B.The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.
• C.The subsetting IF statement works on observations before they are read into the PDV.
• D.The WHERE statement can be executed conditionally as part of an IF statement.

The following SAS program is submitted:
% let a = cat;
% macro animal(a = frog);
% let a = bird;
% mend;
% animal(a = pig)
% put a is &a;
Which one of the following is written to the SAS log?

• A.a is cat
• B.a is bird
• C.a is pig
• D.a is &a

Following SAS program is submitted:
data temp(<insert option here>);
infile 'rawdata';
input x $ y z;
run;
RAWDATA is a file reference to an external file that is ordered by the variable X.
Which option specifies how the data in the SAS data set TEMP will be sorted?

• A.SORTSYNC=X
• B.SORTEDBY=X
• C.GROUPBY=X
• D.ORDEREDBY=X

The following SAS program is submitted:
data temp;
length 1 b 3 x;
infile 'file reference';
input a b x;
run;
What is the result?

• A.The data set TEMP is not created because variable A has an invalid length
• B.The data set TEMP is created and variable X has a length of 8
• C.The data set TEMP is not created because variables A and B have invalid lengths
• D.The data set TEMP is created, but variable X is not created

Given the following SAS data sets ONE and TWO:
ONE TWO
NUM CHAR1 NUM CHAR2
1 A 2 X
2 B 3 Y
4 D 5 V
The following SAS program is submitted creating the output table THREE:
data three;
set one two;
run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V
Which one of the following SQL programs creates an equivalent SAS data set THREE?

• A.proc sql;
  create table three as
  select *
  from one
  union corr
  select *
  from two;
  quit;
• B.proc sql;
  create table three as
  select *
  from one
  outer union corr
  select *
  from two;
  quit;
• C.proc sql;
  create table three as
  select *
  from one
  outer union
  select *
  from two;
  quit;
• D.proc sql;
  create table three as
  select *
  from one
  outer union
  select *
  quit;