I am trying put all the sas datastep into proc sql steps. below is the question and the scenario. 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 to do these two proc sort statements inside proc sql statement itself.
... View more