sas 123 would anybody tell me the answer for this one and why? Thanks.

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

The following SASprogram is submitted: data work.test;

First = 'Ipswich,England'; City = substr(First,1,7);

City_Country=City!!'; '!!'England'; run;

Which one of thefollowing is the value of the variable CITY_COUNTRY in the outputdata set?

A. Ipswich!!

B. Ipswich, EnglandC. Ipswich, 'England'

D. Ipswich , England

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：anybody Answer thanks Thank Would

楼主你把题目打错啦，不然一个正确答案都没有哦。
这是123题中的72题，

The following SAS program is submitted:

data work.test;
First = 'Ipswich, England';
City = substr(First,1,7);
City_Country=City!!'，'!!'England';
run;

Which one of thefollowing is the value of the variable CITY_COUNTRY in the outputdata set?

A. Ipswich!!
B. Ipswich, England
C. Ipswich, 'England'
D. Ipswich , England

根据书上说的，if the SUBSTR function returns a value to a variable that was not yet assigned a length, by defaulf, the variable length is determined by the length of the first argument.
if you omit the length, SAS extracts the remainder of the expression

所以答案是D，表明了City的长度不止7，后面应该有空格才对。

谢谢 我还没懂 我的d不是也有空格吗