topic SAS Proc steps with the data step in SAS Programming

SAS Proc steps with the data step

dht115 — Wed, 14 Sep 2022 19:29:00 GMT

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;

Re: SAS Proc steps with the data step

PaigeMiller — Wed, 14 Sep 2022 19:40:46 GMT

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'