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

The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
EMPLOYEE SALARY
name age name salary
Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?

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

The following SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

• A.Senior Pilot
• B.SENIOR PILOT
• C.Unknown
• D.' ' (missing character value)

Which one of the following is true when SAS encounters a data error in a DATA step?

• A.A note is written to the SAS log explaining the error, and the DATA step continues to execute.
• B.A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
• C.The DATA step stops executing at the point of the error, and no SAS data set is created.
• D.The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.

The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:

What is the length of the Name variable in the data set WORK STAFF_UPDATE?

• A.10
• B.15
• C.20
• D.8

Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

The following SAS program is submitted:
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
Which output is correct?