sas base 123题中的第91 题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

sas base 123题中的第91 题
The following SAS program is submitted:
proc report data = work.houses nowd;
column style price;
where prices <100000;
<insert DEFINE statements here>
title;
run;
Exhibit: the output from the REPORT procedure.

Assume permanent variable labels have been assigned.
Which one of the following completes the program and produces the output
displayed in the exhibit?
A. define style / display width = 9;
define price / sum format = comma9. width = 10;
B. define style / width = 9;
define price / sum format = comma9. width = 10;
C. define style / group width = 9;
define price / sum format = comma9. width = 10;
D. define style / order width = 9;
define price / sum format = comma9. width = 10;

answer:D     why?

A后用display 为什么不可以?  sum group display across 的用法

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：SAS base Base proc report following Program statements following permanent procedure produces

A: "DISPLAY"选项会把'style'的每条记录都列出来；
B：DEFINE后无选项，按默认"DISPLAY"处理；
C: "GROUP"和"SUM"联合使用的话，每个"GROUP"只显示一条汇总结果；
D: "ORDER"与"DISPLAY"的区别是同一个组别'style'只显示一次。

extension 发表于 2016-1-14 17:37
A: "DISPLAY"选项会把'style'的每条记录都列出来；
B：DEFINE后无选项，按默认"DISPLAY"处理；
C: "GROUP ...

最近在学，受教了

“group” creates one row for each unique value of the variable,
while “order” creates one row for each observation with rows arranged according to the values of the order variable.
So the option is “order” here.

extension 发表于 2016-1-14 17:37
A: "DISPLAY"选项会把'style'的每条记录都列出来；
B：DEFINE后无选项，按默认"DISPLAY"处理；
C: "GROUP ...

简单明了，感谢感谢！