求助index函数的使用

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

求助各位大侠
问题：
x,y分别是两个变量，字符型
现在我想看x中是否含有y这个字符串，含的话赋值c=y否则c=0

我的程序如下：
if index(x,y)>0 then c=y;
else c=0;
可是结果总是显示c=0

请问大侠这是什么原因，谢谢

扫码加我 拉你入群

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

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

分享0 收藏1 回帖

关键词：Index IND 是什么原因 各位大侠 else 求助 函数 Index

Samples from SAS.com

For these examples STRING = "ABCDEFG"

Code                Return
INDEX(STRING,'C')   3 (the position of the 'C')
INDEX(STRING,'DEF') 4 (the position of the 'D')
INDEX(STRING,'X')   0 (no "X" in the string)
INDEX(STRING,'ACE') 0 (no "ACE" in the string)

It looks your code is OK. The following code may help to solve your problem.

%let X = "abcdefg";
%let A = "a";
%let F = "f";
%let H = "h";

data _null_;

    if index(&X,&A) > 0 then %put A is &A;
    if index(&X,&F) > 0 then %put F is &F;
    if index(&X,&H) NG 0 then %put H is not found;;

Run;

谢谢你的回复

可是还是不太明白

你下面的这些语句的意思是？

谢谢

If your code is working inside Data step, and X, Y are variable of the dataset you are working with, then the code will be fine.

But if your code is working inside Data step, and neither X or Y is the variable of the dataset you are working with, then SAS will treat X, Y as two new variables without iniitalization. The code will run as you have stated, just make C = 0 all the way.

If you run the code, you will find the result in the log file.

Good luck

[此贴子已经被作者于2008-7-23 21:18:21编辑过]

data temp;
x='123a456';
y='a';
format c $1.0;
if index(x,y)>0 then c=y;
else do
     num_c=input(c,1.0);
     num_c=0;
     end;
run;

弄明白了

用index(x,strip(y))则可以了

waxinigou 发表于 2008-7-24 10:09
弄明白了用index(x,strip(y))则可以了

不行吧？
测试过

data temp;
input x $ y $;
cards;
abc d
abc a
;

data temp2;
set temp;
if index(x,strip(y))>0 then c=y;
else c=0;
run;

data temp3;
set temp;
if index(x,y)>0 then c=y;
else c=0;
run;

data temp4;
set temp;
if index(x,strip(y))>0 then c=y;
else c='0';
run;


这几个例子可以借鉴一下，我觉得应该是数据本身的问题