https://communities.sas.com/t5/SAS-Programming/Finding-cells-with-subset-of-another-cell/m-p/783988#M250101 <PRE><CODE class=" language-sas">if find(new,strip(master)) then condition_desired ="Yes"; else condition_desired ="No";</CODE></PRE> Fri, 03 Dec 2021 18:34:18 GMT Kurt_Bremser 2021-12-03T18:34:18Z https://communities.sas.com/t5/SAS-Programming/Finding-cells-with-subset-of-another-cell/m-p/783982#M250099 <P>Hello</P><P>&nbsp;</P><P>I have the first 2 columns on the following dataset, and I would like to obtain the third column. The third column is a "Yes" if it contains a subset of the First cell, and "No" otherwise. Thank you in advance:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>Master</STRONG></TD><TD><STRONG>New</STRONG></TD><TD><STRONG>Condition_Desired</STRONG></TD></TR><TR><TD>Order_UNIQ_ID</TD><TD>Program_Order_UNIQ_ID</TD><TD>Yes</TD></TR><TR><TD>PRVDR_STATE_Program_ID</TD><TD>Program_PRVDR_STATE_Program_ID</TD><TD>Yes</TD></TR><TR><TD>RCPNT_STATE_Program_ID</TD><TD>Program_RCPNT_STATE_Program_ID</TD><TD>Yes</TD></TR><TR><TD>SUBMTG_Program_LCL_STATE_CD</TD><TD>Program_SUBMTG_LCL_STATE_CD</TD><TD>No</TD></TR><TR><TD>Order_RCPNT_1ST_NAME</TD><TD>BENE_RCPNT_1ST_NAME</TD><TD>No</TD></TR></TBODY></TABLE> Fri, 03 Dec 2021 18:17:05 GMT https://communities.sas.com/t5/SAS-Programming/Finding-cells-with-subset-of-another-cell/m-p/783982#M250099 altijani 2021-12-03T18:17:05Z https://communities.sas.com/t5/SAS-Programming/Finding-cells-with-subset-of-another-cell/m-p/783988#M250101 <PRE><CODE class=" language-sas">if find(new,strip(master)) then condition_desired ="Yes"; else condition_desired ="No";</CODE></PRE> Fri, 03 Dec 2021 18:34:18 GMT https://communities.sas.com/t5/SAS-Programming/Finding-cells-with-subset-of-another-cell/m-p/783988#M250101 Kurt_Bremser 2021-12-03T18:34:18Z