Hey guys! I used your ideas and came up with this simple answer. Thank you so much for all the suggestions. This community is the best!!
proc sql;
create table test as
select x,
(select max(y) from t2) as y
from t1
where x > (select max(y) from t2)
union
(select min(y) from t2 where y>=x) as y
where t1;
quit;
Hi, if I wanna find the nearest lower one, I just change max to min lie following
(select min(y) from t2) as y
where x > (select min(y) from t2)
(select max(y) from t2 where y<=x) as y
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.