https://communities.sas.com/t5/SAS-Programming/Inputs-of-a-characteristic-variable-are-included-in-another/m-p/592389#M169839 <P>Hello,</P><P>&nbsp;</P><P>I want to determine whether CHAR2 variable is included in CHAR1 variable.</P><P>&nbsp;</P><P>If CHAR2's inputs are all included in CHAR1, then want variable has a value of 1. Otherwise, it has a value of 0.</P><P>&nbsp;</P><P>The data and the desired results are as follows:</P><P>&nbsp;</P><P>Data:</P><TABLE><TBODY><TR><TD>Obs</TD><TD>CHAR1</TD><TD>CHAR2</TD></TR><TR><TD>1</TD><TD>A001940, A007280</TD><TD>.</TD></TR><TR><TD>2</TD><TD>A001940, A007280</TD><TD>.</TD></TR><TR><TD>3</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD></TR><TR><TD>4</TD><TD>A001940</TD><TD>A001940, A007280</TD></TR><TR><TD>5</TD><TD>A001940, A007280</TD><TD>A001940</TD></TR><TR><TD>6</TD><TD>A001940, A007280</TD><TD>A001940</TD></TR><TR><TD>7</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD></TR><TR><TD>8</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD></TR><TR><TD>9</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD></TR><TR><TD>10</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD></TR><TR><TD>11</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD></TR><TR><TD>12</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD></TR><TR><TD>13</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD></TR><TR><TD>14</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR><TR><TD>15</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR><TR><TD>16</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR><TR><TD>17</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><BR />Desired result:</P><TABLE><TBODY><TR><TD>Obs</TD><TD>CHAR1</TD><TD>CHAR2</TD><TD>want</TD></TR><TR><TD>1</TD><TD>A001940, A007280</TD><TD>.</TD><TD>0</TD></TR><TR><TD>2</TD><TD>A001940, A007280</TD><TD>.</TD><TD>0</TD></TR><TR><TD>3</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>4</TD><TD>A001940</TD><TD>A001940, A007280</TD><TD>0</TD></TR><TR><TD>5</TD><TD>A001940, A007280</TD><TD>A001940</TD><TD>1</TD></TR><TR><TD>6</TD><TD>A001940, A007280</TD><TD>A001940</TD><TD>1</TD></TR><TR><TD>7</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>8</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>9</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>10</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>11</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>12</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD><TD>1</TD></TR><TR><TD>13</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD><TD>1</TD></TR><TR><TD>14</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>1</TD></TR><TR><TD>15</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>1</TD></TR><TR><TD>16</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>0</TD></TR><TR><TD>17</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>0</TD></TR></TBODY></TABLE><P><BR /><BR />I tried the following solution, but it doesn't apply because the order of input is different.</P><P>&nbsp;</P><P>Want = (indexw(CHAR1,CHAR2,', ')&gt;0);</P><P><BR />If you know the solution, please help me.</P> Sat, 28 Sep 2019 13:46:44 GMT cool1993 2019-09-28T13:46:44Z https://communities.sas.com/t5/SAS-Programming/Inputs-of-a-characteristic-variable-are-included-in-another/m-p/592389#M169839 <P>Hello,</P><P>&nbsp;</P><P>I want to determine whether CHAR2 variable is included in CHAR1 variable.</P><P>&nbsp;</P><P>If CHAR2's inputs are all included in CHAR1, then want variable has a value of 1. Otherwise, it has a value of 0.</P><P>&nbsp;</P><P>The data and the desired results are as follows:</P><P>&nbsp;</P><P>Data:</P><TABLE><TBODY><TR><TD>Obs</TD><TD>CHAR1</TD><TD>CHAR2</TD></TR><TR><TD>1</TD><TD>A001940, A007280</TD><TD>.</TD></TR><TR><TD>2</TD><TD>A001940, A007280</TD><TD>.</TD></TR><TR><TD>3</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD></TR><TR><TD>4</TD><TD>A001940</TD><TD>A001940, A007280</TD></TR><TR><TD>5</TD><TD>A001940, A007280</TD><TD>A001940</TD></TR><TR><TD>6</TD><TD>A001940, A007280</TD><TD>A001940</TD></TR><TR><TD>7</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD></TR><TR><TD>8</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD></TR><TR><TD>9</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD></TR><TR><TD>10</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD></TR><TR><TD>11</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD></TR><TR><TD>12</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD></TR><TR><TD>13</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD></TR><TR><TD>14</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR><TR><TD>15</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR><TR><TD>16</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR><TR><TD>17</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><BR />Desired result:</P><TABLE><TBODY><TR><TD>Obs</TD><TD>CHAR1</TD><TD>CHAR2</TD><TD>want</TD></TR><TR><TD>1</TD><TD>A001940, A007280</TD><TD>.</TD><TD>0</TD></TR><TR><TD>2</TD><TD>A001940, A007280</TD><TD>.</TD><TD>0</TD></TR><TR><TD>3</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>4</TD><TD>A001940</TD><TD>A001940, A007280</TD><TD>0</TD></TR><TR><TD>5</TD><TD>A001940, A007280</TD><TD>A001940</TD><TD>1</TD></TR><TR><TD>6</TD><TD>A001940, A007280</TD><TD>A001940</TD><TD>1</TD></TR><TR><TD>7</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>8</TD><TD>A001940, A007280</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>9</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>10</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>11</TD><TD>A001940, A007280, A104700</TD><TD>A001940, A007280</TD><TD>1</TD></TR><TR><TD>12</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD><TD>1</TD></TR><TR><TD>13</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A104700</TD><TD>1</TD></TR><TR><TD>14</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>1</TD></TR><TR><TD>15</TD><TD>A001940, A007280, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>1</TD></TR><TR><TD>16</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>0</TD></TR><TR><TD>17</TD><TD>A001940, A012160, A104700</TD><TD>A001940, A007280, A012160, A104700</TD><TD>0</TD></TR></TBODY></TABLE><P><BR /><BR />I tried the following solution, but it doesn't apply because the order of input is different.</P><P>&nbsp;</P><P>Want = (indexw(CHAR1,CHAR2,', ')&gt;0);</P><P><BR />If you know the solution, please help me.</P> Sat, 28 Sep 2019 13:46:44 GMT https://communities.sas.com/t5/SAS-Programming/Inputs-of-a-characteristic-variable-are-included-in-another/m-p/592389#M169839 cool1993 2019-09-28T13:46:44Z https://communities.sas.com/t5/SAS-Programming/Inputs-of-a-characteristic-variable-are-included-in-another/m-p/592392#M169841 <P>You will need to examine each word within CHAR2 separately.&nbsp; For example:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">want=0; if char2=' ' then want=1; else do k=1 to countw(char2, ',' ) until (want=1) ; if index(char1, scan(char2, k) ) = 0 then want=1; end;</CODE></PRE> Sat, 28 Sep 2019 14:24:20 GMT https://communities.sas.com/t5/SAS-Programming/Inputs-of-a-characteristic-variable-are-included-in-another/m-p/592392#M169841 Astounding 2019-09-28T14:24:20Z