DATA Step, Macro, Functions and more

Equivalent in SAS

Reply
Super Contributor
Posts: 673

Equivalent in SAS

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

Super User
Posts: 19,789

Re: Equivalent in SAS

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;

Ask a Question
Discussion stats
  • 1 reply
  • 158 views
  • 3 likes
  • 2 in conversation