topic Equivalent in SAS in SAS Programming

Equivalent in SAS

SASPhile — Tue, 08 Jan 2013 19:32:31 GMT

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

Reeza — Tue, 08 Jan 2013 19:57:17 GMT

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;