proc sql is a SAS procedure used to submit SQL statements to the SAS compiler. For Oracle Pro*C, please use [oracle-pro-c].
proc sql; is a SAS procedure used to submit SQL statements to the SAS compiler. It is optionally terminated by a quit; statement. An example of typical syntax would be:
proc sql;
create table z as
select *
from x
left join y
on x.id=y.id
order by 1,2,3;
quit;
A more 'SAS specific' example would be the direct creation of macro variables, such as:
proc sql noprint;
select someVariable into: MyMacroArray separated by ' '
from work.Input where varCondition='True';
For further details on syntax, click here (v9.4) or here (v9.3)
