Finding observations with value closest to a fixed value

[Qhamisafeketsha]

Hi all

I want to keep an observation with a variable closet to a fixed value.

Example:

Data contain;
Input age rank;
85 0
84 1
86 2
83 3
87 4
88 5
89 6
90 7
91 8
92 9
93 10
94 11
95 12
96 13
97 14
98 15
99 16;

So, I want to keep the the age close to 100.

[Kurt_Bremser]

Quick SQL:

proc sql;
select *, abs(100 - age) as dist
from contain
having dist = min(dist)
;
quit;