. 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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.