CODEWITHSUNDEEP
sas
geetha anand
geetha anand

Reputation: 1

Including proc sort in proc sql

Below sample data is from oracle database

promo   flag
vijay    a
vijay    b
vijay    c
sam      b
sam      g
sam      c

I have one proc sql statement connected to oracle(though i have not mentioned oracle connection below) 

proc sql;
create table a as select *from new;
quit;

then two proc sort statement based on above dataset a.

 proc sort data = a;
 by promo descending flag;
 run;
 proc sort data =a nodupkey out =new1;
 by promo;
 run;

Now I want do these two proc sort statements inside proc sql statement itself. Any idea how to do?

Upvotes: 0

Views: 925

Answers (1)

Shenglin Chen
Shenglin Chen

Reputation: 4554

proc sql;
    create table want as
    select distinct promo,flag from new group by promo having flag=max(flag);
quit;

Upvotes: 1

Related Questions