全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
5804 13
2010-08-19
在考试前想问一下70题里自己没搞定的几道题,有劳高手啦,谢谢

--------------------------------------------------------
29.The following SAS program is sumbitted:

  data WORK.INFO;
     infile 'DATAFILE.TXT';
     input @1 Company $20. @25 State $2. @;
     if State=' ' then input @30 Year;
     else input @30 City Year;
     input NumEmployees;
  run;

How many raw data records are read during each iteration of the DATA step?

     A. 1
     B. 2
     C. 3
     D. 4

Answer: A

为什么是一个呢
-------------------------------------------------------------

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
---------------------------------------

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函数还是不太懂
只知道find(string,find-string, modifiers, starting-position)
-----------------------------------------------
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
不明白为什么不是A
-----------------------------------------
35和44看上去是同一类型,看来这方面不太熟悉
二维码

扫码加我 拉你入群

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

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

全部回复
2010-8-19 09:59:35
--------------------------------------------------------
29.The following SAS program is sumbitted:

  data WORK.INFO;
     infile 'DATAFILE.TXT';
     input @1 Company $20. @25 State $2. @;
     if State=' ' then input @30 Year;
     else input @30 City Year;
     input NumEmployees;
  run;

How many raw data records are read during each iteration of the DATA step?

     A. 1
     B. 2
     C. 3
     D. 4

Answer: A

为什么是一个呢

---------------------------------------------
个人认为应该是B,请高手解答。
-------------------------------------------------------------

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
---------------------------------------------
OUTPUT; 会将该行数据输出到所有data行的三个数据集中,
if语句中的output会将满足if条件的记录输出到指定的数据集中。
---------------------------------------


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函数还是不太懂
只知道find(string,find-string, modifiers, starting-position)
----------------------------------------------------
modifier:i表示不区分大小写。
starting-position:这里是5,表示从第五个字母开始(即从'ralia, US, Denmark'中)找“US”;
-----------------------------------------------
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
不明白为什么不是A

--------------------------------
DATA行缺少分号。
-----------------------------------------
二维码

扫码加我 拉你入群

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

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

2010-8-20 00:53:59
谢谢pobel前辈
我也觉得29应该是B,不知道其他人有什么见解

find的函数还是不太明白为什么答案是12,不知道如何得出的
二维码

扫码加我 拉你入群

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

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

2010-8-20 07:26:25
data WORK.ONE;
     Text='Australia, US, Denmark';
     Pos=find(Text,'US','i',5);
  run;

这里的FIND函数是从text字符串的第五个字符开始往后找第一次出现“US”的位置(不区分大小写)。
在该字符串中,第一次出现“US”是在两个逗号之间,分别是text字符串的第12和第13个字符,因此find函数会返回12.
二维码

扫码加我 拉你入群

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

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

2010-8-20 07:33:44
data WORK.ONE;
     Text='Australia, US, Denmark';
     Pos1=find(Text,'US','i',5);
     pos2=find(text,"US","i");
     pos3=find(text,"US");   
     pos4=find(text,"US ","t");
     pos5=find(text,"US ");
     pos6=find(text,"US  ","it");

     put pos1=;
     put pos2=;
     put pos3=;
     put pos4=;
     put pos5=;
     put pos6=;
  run;


pos2: 'Australia, US, Denmark'
pos3: 'Australia, US, Denmark'
pos4: 'Australia, US, Denmark'
pos5: 没有找到“US ”
pos6: 'Australia, US, Denmark'
二维码

扫码加我 拉你入群

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

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

2010-8-21 00:47:22
29 题:因为每次iteration只能度一个record.
35 题:第一个if output 2 observations to sasuer.one, 第二个if ouput 2 observations to sasuser.two. 然后statement output itself 给每一个新dataset 3 observations.
二维码

扫码加我 拉你入群

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

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

点击查看更多内容…
相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群