https://communities.sas.com/t5/SAS-Programming/How-to-keep-very-close-values-of-a-continuous-variable/m-p/640763#M190935 Thank you ! Fri, 17 Apr 2020 15:09:49 GMT Mathis1 2020-04-17T15:09:49Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-very-close-values-of-a-continuous-variable/m-p/640659#M190888 <P>Hello there !</P><P>I'm looking to keep in a table the observations whose values of a price variable are close, for instance (1% to each other).</P><P>&nbsp;</P><P>For instance&nbsp;</P><P>Obs1 - 356.12</P><P>Obs 13 - 356.13</P><P>Obs 26 - 234.13</P><P>Obs 73 - 234.14</P><P>Etc...</P><P>&nbsp;</P><P>Thanks a lot for your help !<BR /><BR />(I precise that I do not have a very advanced level on SAS)</P> Fri, 17 Apr 2020 09:57:02 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-very-close-values-of-a-continuous-variable/m-p/640659#M190888 Mathis1 2020-04-17T09:57:02Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-very-close-values-of-a-continuous-variable/m-p/640663#M190890 <P>Sort by the price variable, then you can use lag() and a look-ahead to compare with previous and following values.</P> <P>For (tested) code, provide an example of your dataset in usable form (a data step with datalines).</P> Fri, 17 Apr 2020 10:35:35 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-very-close-values-of-a-continuous-variable/m-p/640663#M190890 Kurt_Bremser 2020-04-17T10:35:35Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-very-close-values-of-a-continuous-variable/m-p/640763#M190935 Thank you ! Fri, 17 Apr 2020 15:09:49 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-very-close-values-of-a-continuous-variable/m-p/640763#M190935 Mathis1 2020-04-17T15:09:49Z