SAS中文论坛

标题: 跟crakman做sas base认证试题（41） [打印本页]

作者: shiyiming 时间: 2010-11-12 18:27
标题: 跟crakman做sas base认证试题（41）
From crackman's blog on Baidu

41.Given the raw data record in the file phone.txt: 
 
----|----10---|----20---|----30---| 
Stevens James SALES 304-923-3721 14 
 
The following SAS program is submitted: 
 
data WORK.PHONES; 
    infile 'phone.txt'; 
    input EmpLName $ EmpFName $ Dept $ Phone $ Extension; 
    <_insert_code_> 
run; 
 
Which SAS statement completes the program and results in a value of "James Stevens" for the variable FullName?
     A. FullName=CATX(' ',EmpFName,EmpLName); 
     B. FullName=CAT(' ',EmpFName,EmpLName); 
     C. FullName=EmpFName!!EmpLName; 
     D. FullName=EmpFName + EmpLName; 
Answer: A
本文属于博客：<a href="http://hi.baidu.com/crack_man/home"><a class="postlink" href="http://hi.baidu.com/crack_man/home">http://hi.baidu.com/crack_man/home</a></a> 版权归作者所有，欢迎转载！如有转载，请务必注明出处！未经本文作者同意不得用于商业应用。
本题考察的是函数CATX的用法。 
先看看SAS 对CATX的解释： 
去除变量前后的空格符，插入分隔符，返回连接后的字符串。 
请思考：是先处理要准备连接的每一个变量的前后空格符，还是连接号之后再除去连接后的变量的前后空格符？连接后的变量默认长度是好多呢？这个函数与CAT函数的差别是什么呢？ 
Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string. 
-------------------------------------------------------------------------------- 
Syntax 
CATX(delimiter, item-1 <, ...item-n>) 
Arguments
delimiter 
specifies a character string that is used as a delimiter between concatenated items. 
item 
specifies a constant, variable, or expression, either character or numeric. If item is numeric, then its value is converted to a character string by using the BESTw. format. In this case, SAS does not write a note to the log. For more information, see The Basics. 
更多的请看： 
<a href="http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a002257076.htm"><a class="postlink" href="http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a002257076.htm">http://support.sas.com/documentation/cd ... 257076.htm</a></a>
 
 <a href="http://hi.baidu.com/crack%5Fman/blog/item/6c900a4ba3fda226aec3ab73.html">阅读全文</a>

 类别：<a href="http://hi.baidu.com/crack%5Fman/blog/category/%B8%FAcrackman%D7%F6sas%20base%C8%CF%D6%A4%CA%D4%CC%E2">跟crackman做sas base认证试题</a> <a href="http://hi.baidu.com/crack%5Fman/blog/item/6c900a4ba3fda226aec3ab73.html#comment">查看评论</a>

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)