topic Re: filter data in New SAS User https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517680#M3383 <PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token keyword">if</SPAN> <SPAN class="token function">substr</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token keyword">id</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">3</SPAN><SPAN class="token punctuation">,</SPAN> 2<SPAN class="token punctuation">)</SPAN> <SPAN class="token operator">=</SPAN> "RE" <SPAN class="token keyword">then</SPAN> <SPAN class="token function">delete</SPAN><SPAN class="token punctuation">;</SPAN></CODE></PRE> <P>&nbsp;</P> <P>3 is starting position and 2 is length and you need quotes around the value&nbsp;</P> Fri, 30 Nov 2018 22:01:16 GMT kiranv_ 2018-11-30T22:01:16Z filter data https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517676#M3379 <P>Hello! My data set has an ID number (character variable) and I want to filter some of observations.</P><P>&nbsp;</P><P>The criteria is if the 3rd and the 4th digits are "RE", then delete.</P><P>&nbsp;</P><P>For example, if the ID is ABRE5550, this observation should be deleted.</P><P>&nbsp;</P><P>What code do I need to use?&nbsp;</P><P>&nbsp;</P><P>Thanks.</P> Fri, 30 Nov 2018 21:53:52 GMT https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517676#M3379 dapenDaniel 2018-11-30T21:53:52Z Re: filter data https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517677#M3380 Look at the SUBSTR() function. Fri, 30 Nov 2018 21:53:56 GMT https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517677#M3380 Reeza 2018-11-30T21:53:56Z Re: filter data https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517678#M3381 <PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token keyword">if</SPAN> <SPAN class="token function">substr</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token keyword">id</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">3</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">4</SPAN><SPAN class="token punctuation">) = RE</SPAN> <SPAN class="token keyword">then</SPAN> <SPAN class="token function">delete</SPAN><SPAN class="token punctuation">;</SPAN></CODE></PRE><P>Is it correct?&nbsp;</P> Fri, 30 Nov 2018 21:55:26 GMT https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517678#M3381 dapenDaniel 2018-11-30T21:55:26Z Re: filter data https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517679#M3382 Is RE a variable or text? If it's text it needs to be in quotes, if it's a variable then it's fine. Fri, 30 Nov 2018 21:59:49 GMT https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517679#M3382 Reeza 2018-11-30T21:59:49Z Re: filter data https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517680#M3383 <PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token keyword">if</SPAN> <SPAN class="token function">substr</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token keyword">id</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">3</SPAN><SPAN class="token punctuation">,</SPAN> 2<SPAN class="token punctuation">)</SPAN> <SPAN class="token operator">=</SPAN> "RE" <SPAN class="token keyword">then</SPAN> <SPAN class="token function">delete</SPAN><SPAN class="token punctuation">;</SPAN></CODE></PRE> <P>&nbsp;</P> <P>3 is starting position and 2 is length and you need quotes around the value&nbsp;</P> Fri, 30 Nov 2018 22:01:16 GMT https://communities.sas.com/t5/New-SAS-User/filter-data/m-p/517680#M3383 kiranv_ 2018-11-30T22:01:16Z