Simplest Select satament
proc sql;
select *
from sashelp.cars;
quit;
Where
proc sql;
select *
from sashelp.cars
where make="Honda";
quit;
Group
proc sql;
select *
from sashelp.cars
where make="Honda"
group by make;
quit;
As - renaming a variable as something else
proc sql;
select sum(price) as Total_Price
from sashelp.cars;
where make="Honda"
quit;
Having
- run; doesn't have any effect. You can use quit; instead.