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

The following SAS program is submitted:
% macro loop;
data one;
% do I=1 %to 3;
var&I=&I;%
end
run;
% mend;
% loop
After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?

• A.MACRO
• B.MLOGIC
• C.SYMBOLGEN
• D.MPRINT

Given the SAS data sets:

A SAS program is submitted and the following is written to SAS to:

What would allow the program to successfully execute without errors?

• A.Replace the equal sign with In operator.
• B.Replace the where clause with:
  Where EMPLOYEE.Name = (Select Names delimited with ','
  From WORK.NEWEMPLOYEE
  Where Salary > 40000);
• C.Qualify the column names with the table names.
• D.Replace the 104 with:
  Where EMPLOYEE.Name = Any (Select names separated with ','
  From WORK.NEWEMPLOYEE
  Where Salary > 40000);

The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and
LABEL and it consists of 10 observations.
The following SAS program is submitted:
Proc format cntlin=wor.tempdata;
Run;
What is the result of submitting the FORMAT procedure step?

• A.All formats created will be stored in two WORK.TEMPDATA SAS data set
• B.It uses the WORK.TEMPDATA SAS data set as input to create the format
• C.An ERROR message is written to the SAS log because the program is incomplete
• D.NO formats are created in this step

The following SAS FORMAT procedure is submitted:
proc format lib = sasuser;
value tempc low < 0 = 'BELOW FREEZING'
0 < 5 = 'COLD'
5 < 10 = 'MILD'
10 < 15 = 'WARM'
15 high = 'HOT';
run;
How is the value 10 displayed when the format TEMPC is applied?

• A.BELOW FREEZING
• B.WARM
• C.10
• D.MILD

Given the following SAS data sets ONE and TWO:
ONE TWO
OBS COMMON X OBS COMMON Y
1 A 10 1 A 1
2 A 13 2 A 3
3 A 14 3 B 4
4 B 9 4 B 2
5 C 8 5 C 5
6 C 14
The following SAS DATA step is submitted:
data combine;
merge one two;
by common;
run;
Which one of the following represents the data values stored in data set COMBINE?

• A.OBS COMMON X Y
  1 A 10 1
  2 A 13 3
  3 A 14 3
  4 B 9 4
  5 B 9 2
  6 C 8 5
  7 C 14 5
• B.OBS COMMON X Y
  1 A 10 1
  2 A 13 3
  3 B 14 4
  4 B 9 2
  5 C 8 5
• C.OBS COMMON X Y
  1 A 10 1
  2 A 13 1
  3 A 14 1
  4 A 10 3
  5 A 13 3
  6 A 14 3
  7 B 9 4
  8 B 9 2
  9 C 8 5
  10 C 14 5
• D.OBS COMMON X Y
  1 A 10 1
  2 A 13 3
  3 B 9 4
  4 C 8 5