topic Re: Select the values near to the zero by group in SAS Programming

Select the values near to the zero by group

Smitha9 — Thu, 25 Aug 2022 19:59:39 GMT

Hi,

I have a dataset

ID Days

1 -78

1 130

2 -98

2 -89

2 -456

3 -57

3 3

I want to select the nearest to the "0" value from the group of ID.

ID Days

1 -78

2 -89

3 3

PGStats — Thu, 25 Aug 2022 20:20:51 GMT

With SQL you could do:

proc sql;
select * 
from mydata
group by id
having abs(days) = min(abs(days));
quit;