topic Re: How to find a particular number from the filed which has series of 24 numbers in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-find-a-particular-number-from-the-filed-which-has-series/m-p/928238#M365209 <P>Not sure why&nbsp;<SPAN>111221122121112121111121 qualifies as Ever2=1 given your rule is "numbers &gt; 2"</SPAN></P> <P>&nbsp;</P> <P>See if below returns what you want. Else just amend the list of digits to search for.</P> <PRE><CODE class=" language-sas">data demo; input digits:$24.; Ever4 = (findc(digits,'56789')&gt;0); Ever2 = (Ever4=0 and findc(digits,'34')&gt;0); datalines; 111221122121112121113121 455444443211113212211221 111111111111111111111111 888887654323221211111111 000000000000000000000000 000000000000000000000000 000000000088888888888888 111111111121111211111111 000000000000011111111111 000000000000000000000000 000000000000000000000000 888888888888888888888888 000000000000110111111211 000000000000000000000000 432232143221212212111111 000000000000000000000000 000000000000001111121111 000000000000000000000000 000000000000000000000000 111111211111111111112112 ; proc print data=demo; run;</CODE></PRE> Tue, 14 May 2024 05:06:49 GMT Patrick 2024-05-14T05:06:49Z How to find a particular number from the filed which has series of 24 numbers https://communities.sas.com/t5/SAS-Programming/How-to-find-a-particular-number-from-the-filed-which-has-series/m-p/928235#M365208 <P>Hi Team,</P><P>&nbsp;</P><P>I have a variable called history which has 24 numbers in it.</P><P>example (111221122121112121111121) - qualifies as Ever2 /455444443211113212211221 qualifies in Ever 4</P><P>&nbsp;</P><P>Can you advise the logic to use to create flags like in the 'history' variable if it has numbers &gt; 2( that comes in the complete series anytime not looking at the position)then Ever2 .</P><P>&nbsp;</P><P>&nbsp;</P><P>I mean in that a particular variable i have 1 2months data...if the history variable has&nbsp; &gt; 2 then Ever2=1, if it has &gt;4 then Ever 4= 1;</P><P>&nbsp;</P><P>thanks for the help.</P><P>&nbsp;</P><P>examples of the records for history.</P><P>&nbsp;</P><P>111111111111111111111111<BR />888887654323221211111111<BR />000000000000000000000000<BR />000000000000000000000000<BR />000000000088888888888888<BR />111111111121111211111111<BR />000000000000011111111111<BR />000000000000000000000000<BR />000000000000000000000000<BR />888888888888888888888888<BR />000000000000110111111211<BR />000000000000000000000000<BR />432232143221212212111111<BR />000000000000000000000000<BR />000000000000001111121111<BR />000000000000000000000000<BR />000000000000000000000000<BR />111111211111111111112112</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 14 May 2024 04:21:15 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-a-particular-number-from-the-filed-which-has-series/m-p/928235#M365208 BaalaRaaji 2024-05-14T04:21:15Z Re: How to find a particular number from the filed which has series of 24 numbers https://communities.sas.com/t5/SAS-Programming/How-to-find-a-particular-number-from-the-filed-which-has-series/m-p/928238#M365209 <P>Not sure why&nbsp;<SPAN>111221122121112121111121 qualifies as Ever2=1 given your rule is "numbers &gt; 2"</SPAN></P> <P>&nbsp;</P> <P>See if below returns what you want. Else just amend the list of digits to search for.</P> <PRE><CODE class=" language-sas">data demo; input digits:$24.; Ever4 = (findc(digits,'56789')&gt;0); Ever2 = (Ever4=0 and findc(digits,'34')&gt;0); datalines; 111221122121112121113121 455444443211113212211221 111111111111111111111111 888887654323221211111111 000000000000000000000000 000000000000000000000000 000000000088888888888888 111111111121111211111111 000000000000011111111111 000000000000000000000000 000000000000000000000000 888888888888888888888888 000000000000110111111211 000000000000000000000000 432232143221212212111111 000000000000000000000000 000000000000001111121111 000000000000000000000000 000000000000000000000000 111111211111111111112112 ; proc print data=demo; run;</CODE></PRE> Tue, 14 May 2024 05:06:49 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-a-particular-number-from-the-filed-which-has-series/m-p/928238#M365209 Patrick 2024-05-14T05:06:49Z Re: How to find a particular number from the filed which has series of 24 numbers https://communities.sas.com/t5/SAS-Programming/How-to-find-a-particular-number-from-the-filed-which-has-series/m-p/928241#M365211 Working, Thank you Tue, 14 May 2024 05:40:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-find-a-particular-number-from-the-filed-which-has-series/m-p/928241#M365211 BaalaRaaji 2024-05-14T05:40:18Z