https://communities.sas.com/t5/SAS-Procedures/Index-function-help/m-p/21246#M4479 You have an answer on another list Tue, 21 Apr 2009 06:13:34 GMT Andre 2009-04-21T06:13:34Z https://communities.sas.com/t5/SAS-Procedures/Index-function-help/m-p/21245#M4478 Hi, <BR /> <BR /> I have a column <BR /> Data set 1 <BR /> Book type Author <BR /> fiction raddy <BR /> fiction bosco <BR /> science srins <BR /> science srins <BR /> <BR /> <BR /> data set 2 <BR /> <BR /> <BR /> I have many columns in data set 2. However one of the column say <BR /> description has entries about the author <BR /> <BR /> <BR /> description <BR /> <BR /> <BR /> raddy 99 version 1.0 vol 1 <BR /> bosco 78 version 5.0 vol 8 <BR /> srins99 version 2.0 vol1 <BR /> srins_78 version7.0 vol1 <BR /> <BR /> <BR /> I did a full join and have both the columns in data set 3. Now I need a way to find out whether the string in column author is there in column description.<BR /> <BR /> The code should result as<BR /> author description flag <BR /> raddy raddy y<BR /> bosco bosco y<BR /> <BR /> <BR /> For example raddy is there in the description and author so a flag <BR /> colum would be set to Y. <BR /> <BR /> <BR /> Please help Mon, 20 Apr 2009 21:30:08 GMT https://communities.sas.com/t5/SAS-Procedures/Index-function-help/m-p/21245#M4478 deleted_user 2009-04-20T21:30:08Z https://communities.sas.com/t5/SAS-Procedures/Index-function-help/m-p/21246#M4479 You have an answer on another list Tue, 21 Apr 2009 06:13:34 GMT https://communities.sas.com/t5/SAS-Procedures/Index-function-help/m-p/21246#M4479 Andre 2009-04-21T06:13:34Z https://communities.sas.com/t5/SAS-Procedures/Index-function-help/m-p/21247#M4480 Just use it as documented...;-)<BR /> <BR /> SQL style:<BR /> case when index(description,author) then "y" else "n" end as flag<BR /> <BR /> /Linus Tue, 21 Apr 2009 06:15:29 GMT https://communities.sas.com/t5/SAS-Procedures/Index-function-help/m-p/21247#M4480 LinusH 2009-04-21T06:15:29Z