SAS70第35题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

35.given the SAS data set SASDATA.TWO:

  X  Y
  -- --
  5  2
  3  1
  5  6

The following SAS program is submitted:
  data SASUSER.ONE  SASUSER.TWO  OTHER;
     set SASDATA.TWO;
     if X eq 5 then output SASUSER.ONE;
     if Y lt 5 then output SASUSER.TWO;
     output;
  run;

What is the result?

     A.
data set SASUSER.ONE has 5 observations   
data set SASUSER.TWO has 5 observations
data set WORK.OTHER  has 3 observations

     B.
data set SASUSER.ONE has 2 observations   
data set SASUSER.TWO has 2 observations
data set WORK.OTHER  has 1 observations

     C.
data set SASUSER.ONE has 2 observations   
data set SASUSER.TWO has 2 observations
data set WORK.OTHER  has 5 observations

     D. No data sets are output. The DATA step fails execution due to syntax errors.

Answer: A

求高人指点解题思路！谢谢！

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：observations observation following EXECUTION Data step following result

再问一题：42.The following SAS program is submitted:

  data WORK.ONE;
     Text='Australia, US, Denmark';
     Pos=find(Text,'US','i',5);
  run;

What value will SAS assign to Pos?

     A. 0
     B. 1
     C. 2
     D. 12

Answer: D
------------------------------------------------------------------      
find statement括号里各部分都代表什么意思啊？谢谢！

44.The following SAS program is submitted:

  data ONE TWO SASUSER.TWO
     set SASUSER.ONE;
  run;

Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

     A. 2 temporary and 1 permanent SAS data sets are created
     B. 3 temporary and 2 permanent SAS data sets are created
     C. 2 temporary and 2 permanent SAS data sets are created
     D. there is an error and no new data sets are created

Answer: D
------------------------------------------------------------------      
是什么error啊？

44 最简单
data ONE TWO SASUSER.TWO 没有;

35
运行下面的code后，SASUSER.ONE  SASUSER.TWO  OTHER各有3个observations，
  data SASUSER.ONE  SASUSER.TWO  OTHER;
     set SASDATA.TWO;

运行 if X eq 5 then output SASUSER.ONE;
     if Y lt 5 then output SASUSER.TWO;
后，SASUSER.ONE  SASUSER.TWO各增加2个observation

data WORK.ONE;
     Text='Australia, US, Denmark';
     Pos=find(Text,'US','i',5);

从"Text" 找"US".

visiting 发表于 2012-9-11 05:39
data WORK.ONE;
     Text='Australia, US, Denmark';
     Pos=find(Text,'US','i',5);

那请问i和5分别是什么意思呢？谢谢！

35题：
如果X小于等于5，则输出到ONE：所以，ONE + 2
如果Y小于5，则输出到TWO：所以，TWO + 2
OUTPUT，总共3条数据：所以，ONE +3, TWO+3, OTHER +3
所以，ONE=5，TWO=5, OTHER=3

42题：Pos=find(Text,'US','i',5);
find：查找
Text：需要查找的数据源
'US'：需要在数据源里面查找的字符
i ：字符不分大小写
5：从数据源第5个字符开始查找（即是忽略 Australia 里面的小写 us）

44题：
data ONE TWO SASUSER.TWO 后面少了个分号  ;