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

The following SAS program is submitted:
data work.clients;
calls = 6;
do while (calls le 6);
calls + 1;
end;
run;
Which one of the following is the value of the variable CALLS in the output data set?

• A.7
• B.4
• C.6
• D.5

The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
< insert IF statement here>
run;
Which one of the following IF statements writes the last observation to the output data set?

• A.if end = 0;
• B.if eof = 1;
• C.if eof = 0;
• D.if end = 1;

Which one of the following statements is true regarding the name of a SAS array?

• A.It can be the same as the name of a variable in the data set.
• B.It exists only for the duration of the DATA step.
• C.It can be used in procedures.
• D.It is saved with the data set.

CORRECT TEXT
The SAS data set QTR1_REVENUE is listed below:

The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue;
run;
Which one of the following represents the first observation in the output data set?

The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
Which one of the following represents how many observations the WORK.TOTAL data set contains?

• A.500
• B.100
• C.20
• D.5