SAS BASE的一道题关于proc report

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

What output does this PROC REPORT step produce?

1. proc report data=sasuser.houses nowd;
   
2. column style sqfeet bedrooms price;
   
3. run;

复制代码

a. a list report ordered by values of the first variable in the COLUMN statement
b. a summary report ordered by values of the first variable in the COLUMN statement

c. a list report that displays a row for each observation in the input data set and which
calculates the SUM statistic for numeric variables

d. a list report that calculates the N (frequency) statistic for character variables


答案是c
然后我不明白，因为我打了程序，也没有计算出数值型数据的SUM

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：proc report SAS base Report repor Base report

这题出得不大好，但它的意思是，在proc report里，那些数值型的变量默认的统计量是求和，原文可以在prep guide里找到：

PROC REPORT uses each variable in one of six ways (DISPLAY, ORDER, GROUP, ACROSS,
ANALYSIS, or COMPUTED). By default, PROC REPORT uses

character variables as display variables

numeric variables as analysis variables, which are used to calculate the SUM statistic.

假如题中的代码任意定义一列是group, 比如：
proc report data=sasuser.houses nowd;
column style sqfeet bedrooms price;
define style /group;
run;

那么这时候其他三个在报表里的变量sqfeet bedrooms price如无额外声明，将自动按组来做求和统计输出。

proc report data=a out=b;
column CMTRT DRUGNAME1;
define CMTRT/order;
define CMTRT/group;
run;
其中CMTRT和DRUGNAME1都是字符变量，提示NOTE: 由于 DRUGNAME1 的用法为 DISPLAY，故未创建组。要避免这一注释，请将所有 GROUP 变量更改为 ORDER 变量。
怎么解决？求大神解答