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

Given the SAS data set EMPLOYEES:
EMPLOYEES
NAME SALARY
-------- ------------
Innis60000
Jolli50000
Ellis55000
Liu45000
The following SAS program is submitted:
proc print data = employees; where name like '_i%';
run;
What is contained in the output?

• A.Innis, Jolli, Ellis, and Liu
• B.Innis, Ellis, and Liu only
• C.Innis and Ellis only
• D.Liu only

The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:

What is output?

• A.Option D
• B.Option A
• C.Option C
• D.Option B

The following SAS program is submitted:
data work.products;
Product_Number = 5461;
Item = '1001';
Item_Reference = Item'/'Product_Number;
run;
Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?

• A.The value can not be determined as the program fails to execute due to errors.
• B.1001/ 5461
• C.. (missing numeric value)
• D.1001/5461

Which one of the following SAS statements renames two variables?

• A.set work.dept1work.dept2(rename = (jcode = jobcode)(sal = salary));
• B.set work.dept1work.dept2(rename = (jcode = jobcodesal = salary));
• C.set work.dept1work.dept2(rename = (jcode jobcode)(sal salary));
• D.set work.dept1work.dept2(rename = jcode = jobcodesal = salary);

After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
-----
22
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
, <=, <>, =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?

• A.(drop Month, Quantity, Cost)
• B.(drop=Month Quantity Cost)
• C.(drop=Month, Quantity, Cost)
• D.(drop Month Quantity Cost)