Hello,
I have following step in proc sql.
How can we get this step in one datastep instead of data and sort procedure
/*Have*/
proc Sql noprint;
create table cars as
select * from sashelp.cars
where upcase(make)="%upcase(HONDA)"
order by length, mpg_city, mpg_highway; /*Replaced element with study_arm_desc variable. DT*/
quit;
/*want*/
data cars;
set sashelp.cars;
if make = "Honda";
*to add sort steps in this step;
run;
proc sort data=cars;
by length, mpg_city, mpg_highway;
run;