topic Re: SAS FILTER QUESTION in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-FILTER-QUESTION/m-p/209695#M267326 <HTML><HEAD></HEAD><BODY><P>data Want;</P><P>input Code_Variable $;</P><P>if length(Code_Variable) eq 5;</P><P>cards;</P><P>10351</P><P>101</P><P>11223040</P><P>32421</P><P>10449900</P><P>;</P></BODY></HTML> Fri, 28 Aug 2015 15:40:32 GMT MadhuKorni 2015-08-28T15:40:32Z SAS FILTER QUESTION https://communities.sas.com/t5/SAS-Programming/SAS-FILTER-QUESTION/m-p/209693#M267324 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>From the below character_variable I only want to pick the ones with 5 digits:</P><P>I want to eliminate the rest. Do I use Substring??</P><P></P><P><SPAN style="color: #ff0000;">CODE_VARIABLE</SPAN></P><P><SPAN style="color: #339966;">10351</SPAN></P><P>101</P><P>11223040</P><P><SPAN style="color: #339966;">32421</SPAN></P><P>10449900</P></BODY></HTML> Fri, 28 Aug 2015 15:37:27 GMT https://communities.sas.com/t5/SAS-Programming/SAS-FILTER-QUESTION/m-p/209693#M267324 robertrao 2015-08-28T15:37:27Z Re: SAS FILTER QUESTION https://communities.sas.com/t5/SAS-Programming/SAS-FILTER-QUESTION/m-p/209694#M267325 <HTML><HEAD></HEAD><BODY><P>Length() function returns the length of a string. </P><P><A href="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245907.htm" title="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245907.htm">SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition</A></P></BODY></HTML> Fri, 28 Aug 2015 15:40:03 GMT https://communities.sas.com/t5/SAS-Programming/SAS-FILTER-QUESTION/m-p/209694#M267325 Reeza 2015-08-28T15:40:03Z Re: SAS FILTER QUESTION https://communities.sas.com/t5/SAS-Programming/SAS-FILTER-QUESTION/m-p/209695#M267326 <HTML><HEAD></HEAD><BODY><P>data Want;</P><P>input Code_Variable $;</P><P>if length(Code_Variable) eq 5;</P><P>cards;</P><P>10351</P><P>101</P><P>11223040</P><P>32421</P><P>10449900</P><P>;</P></BODY></HTML> Fri, 28 Aug 2015 15:40:32 GMT https://communities.sas.com/t5/SAS-Programming/SAS-FILTER-QUESTION/m-p/209695#M267326 MadhuKorni 2015-08-28T15:40:32Z