. Hi I have 2 tables one has 7k. Records table 2 has 14k
i want to bring every thing from table one 7k records and only the data from table 2 matches...enclose is my code
proc sql;
create table temp2 as
select one.*, two.atm as b_atm, two.date as b_date
from one,two
where one.id=two.id and two.date gt one.date
group by one.id
having two.date-one.date =min(two.date-one.date);
create table want2 as
select temp2.*,two.id as c_id ,two.date as c_date
From temp2,two
where temp2.id =two.id and two.date gt temp2.date
group by temp2.id
having two.date- temp2.date=min(two.date-temp2.date);
quit;
thanks for assistance
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.