Proc SQL - A Simple Example


Proc SQL is a SAS(r) procedure that  allows standard SQL statements to be used to interrogate or manipulate SAS data sets or views.

Simple example using proc sql:

proc sql;

create table work.class_out as   /* specify output table */

select age, sex, height          /* specify output variables */

from sashelp.class               /* specify input table */

where age > 11                   /* use a where clause (optional) */

order by age;                    /* sort the output  (optional) */


This example uses the built in sashelp.class data set and can be run from any SAS session to show a simple example of how proc SQL works.