SAS Proc steps with the data step

[dht115]

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;

[PaigeMiller]

How about this:

proc sort data=sashelp.cars out=cars;
    where make='Honda';
    by length mpg_city mpg_highway;
run;

Also, your SQL code can be simplified with

where upcase(make)="HONDA"

or better yet

where make='Honda'