topic Re: approximately equal in SAS Programming

approximately equal

Tecla1 — Fri, 02 Nov 2018 10:17:54 GMT

Hi to all,

i need to take observation that are not stricly > or < of a number but are nearest of a number … which function i need to use?

Many tnks.

Tecla

Re: approximately equal

gamotte — Fri, 02 Nov 2018 10:30:47 GMT

Hello,

Something like this ?

%let precision=1.0e-6;

data have;
input x y;
cards;
1 1.0001
1 0.9999
1 1.0000001
1 0.9999999
;
run;

proc sql;
    CREATE TABLE equals AS
    SELECT *
    FROM have
    WHERE abs(x-y)<&precision.;
quit;

Re: approximately equal

Tecla1 — Fri, 02 Nov 2018 10:42:53 GMT

Hi Tnks for your kindly reply….

non so much because i don't have a dimension for the around , the around can be bigger but the only i have ….

Example:

If I find an around of 75 and I have only one more observation , like 20... my result will be 20....

I'm clear ? excuse for my english…

Tecla

Re: approximately equal

Shmuel — Fri, 02 Nov 2018 10:55:20 GMT

You can compute the difference between the two values as absolute percentage of of the lowest/highest value

and check vs some logical limit/

Re: approximately equal

gamotte — Fri, 02 Nov 2018 10:56:03 GMT

OK, this perhaps then ?

proc sql;
    CREATE TABLE want AS
    SELECT *
    FROM have
    HAVING abs(x-75)=min(abs(x-75));
quit;

Re: approximately equal

Tecla1 — Fri, 02 Nov 2018 11:06:34 GMT

TNKS SO MUCH !!