g****y 发帖数: 188 | 1 Q1:
Given the following SAS program:
proc sql;
select product,type,sum(sales) as revenue
from one
group by product,type;
quit;
which one of the following clauses should be added to the program to sort
the output by PRODUCT and decreasing REVENUE?
A. order by 1,3
B. order by 1,3 desc
C. order by product, revenue desc
D. order by product, desc revenue
为什么答案是B?C不是一样吗?
Q2:
Which SET statement option names a variable but contains the number of the
observation to read during the current iteration of the DATA step?
A.OBS = pointobs
B.KEY = pointobs
C.NOBS =pointobs
D.POINT = pointobs
答案是D。可是我怎么觉得C答案才是呢?NOBS不正是: a variable that represents
the total number of observations in the input data set.
多谢答复,包子随后奉上。 | s******8 发帖数: 102 | 2 1. 我也认为并测试了B,C一样。
2。问的是本次读(操作)的记录,就是point=, 比如读第8条记录;
the number of the observation to read during the current iteration of the
DATA step, Not the number of observations of the dataset; | s****u 发帖数: 1200 | 3 不要包子。
第一题,我感觉是b肯定不会错。最后一个选项因为设计到calculated, 不知道低级版
本的sas会不会报错。
★ 发自iPhone App: ChineseWeb 7.8
【在 g****y 的大作中提到】 : Q1: : Given the following SAS program: : proc sql; : select product,type,sum(sales) as revenue : from one : group by product,type; : quit; : which one of the following clauses should be added to the program to sort : the output by PRODUCT and decreasing REVENUE? : A. order by 1,3
| g****y 发帖数: 188 | | s****u 发帖数: 1200 | 5 收到包子了。你太客气了!我都没帮到忙
★ 发自iPhone App: ChineseWeb 7.8
【在 g****y 的大作中提到】 : 多谢答覆,包子已发。
| s******8 发帖数: 102 | | g****y 发帖数: 188 | 7 汗一个。反正一有祝福之类的,我就去挣包子啊。
★ 发自iPhone App: ChineseWeb 7.8
【在 s******8 的大作中提到】 : 谢谢包子。你是怎样积攒起那么多包子的?
|
|