求助 如何挑选出想要的名字？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

想要找出公司名称中含有toy一词的公司，用下面这个语句：

data b;

set a;

where name ? ‘toy’;

run;

但发现 还找出了其他不需要的，比如toyy company, goodtoy company..... 如何能够精确的找出 只有toy一词 的公司。

比如：

number	name
1	abc toy company
2	zed toyy co.
3	xdy goodtoy com
4	FW TOY LTD

所以只有1 and 4是我想要的，如果用上面的语句就会1 2 3会显示出来，如何才能(1) 只找出有toy一词的, (2) 无论大小写都能显示出来.

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：company compan Number Where comp 求助 名字 挑选

data a;
input number name &$50.;
cards;
1 abc toy company
2 zed tyy co.
3 xdy goodtoy com
4 FW TOY LTD
;run;

proc sql;select * from a where index(lowcase(name) ," toy ");quit;

多谢指点 有所领悟

proc sql

sql功能前大！

1# funwin

It is better to use

where upcase(name)=" TOY "

than  

where index(name ," toy ") or index(name ," TOY ")

It is just my preference.

bobguy 发表于 2009-12-19 12:07
1# funwin
It is better to use
where upcase(name)=" TOY "

but it can only read  "  TOY  " and  "  toy  "
can't solve the problem

xiaosanmao 发表于 2009-12-19 12:54

bobguy 发表于 2009-12-19 12:07
1# funwin
It is better to use
where upcase(name)=" TOY "

but it can only read  "  TOY  " and  "  toy  "
can't solve the problem

Why not?

I saw you modify your previous post after my post. Here is the time mark.



data a;
input number name &$50.;
cards;
1 abc toy company
2 zed tyy co.
3 xdy goodtoy com
4 FW TOY LTD
;run;

proc sql;select * from a where index(lowcase(name) ," toy ");quit;

data a;
input number name &$50.;
cards;
1 abc toy company
2 zed tyy co.
3 xdy goodtoy com
4 FW TOY LTD
;run;

data b;
set a;
where upcase(name) contains ' TOY ';run; 1# funwin

' TOY '  toy 两边各加一个空格