求问SAS BASE 123题第92题。谢谢啦！

5185

收藏 2017-04-19

92 The following SAS program is submitted:

proc report data = sasuser.houses nowd headline headskip;
column style price;
where price <100000;
<insert code here>
title;
run;

Exhibit: output from the REPORT procedure.
Style    Price
RANCH    $64,000
SPLIT    $65,850
CONDO    $80,050
RANCH    $86,650
SPLIT    $94,450
SPLIT    $73,650
CONDO    $79,350
TWOSTORY  $55,850
RANCH    $89,100
TWOSTORY  $69,250
RANCH    $34,500

Assuming that the PRICE variable is numeric, which one of the following completes the program and produces the output displayed in the exhibit?

A.
define style / group 'Style';
define price / mean 'Price' format = dollar9.;

B.
define style / display 'Style';
define price / across 'Price' format = dollar9.;

C.
define style / display 'Style';
define price / sum 'Price' format = dollar9.;

D.
define style / order 'Style';
define price / mean 'Price' format = dollar9.;

请问为啥是C呀？那个SUM是咋回事儿？谢谢！

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

全部回复

Newkoarla

2017-4-19 18:34:36

look at the output column Style, there are multi RANCH and no order, so D and A are not correct answer. the output of Price is single, so no across.

so the right answer is C