How can this be done in two steps instead of one?I would like to separate them and re-merge it later
execute (
select to_id, min(from_id) from_id
into #threcluster
from (
select min(a.to_id) as to_id, a.from_id
from #tmpcluster a
where threshold_ind=1
group by a.from_id
) b
group by to_id
Something like the following should work, you'll have to make sure the table names are aligned the way you'd like.
proc sql;
create table tmpcluster2 as
select min(a.to_id) as to_id, a.from_id
from tmpcluster a
where threshold_ind=1
group by a.from_id;
create table tmpcluster3 as
select to_id, min(from_id) from_id
from tmpcluster2
group by to_id;
quit;
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.