Multiple select/sql statements in PROC SQL

[jffeudo86]

Hi,

I'm fairly new to SAS and was wondering if I can have multiple "queries"/sql statements in proc sql.  Or maybe I just don't know the primary use of proc sql.

Basically, I wanted to know if I need to create multiple proc sqls or do all sql statements in proc sql.  For example, can I have any number of combination of create table/select statements inside one proc sql?

Thanks.

[PaigeMiller]

You can certainly have multiple queries in one PROC SQL

proc sql;
    create table a as select * from sashelp.class where age=14;
    create table b as select make,model,type,origin from sashelp.cars where
          mspr>40000 and horsepower>200;
quit;

[PeterClemmensen · Accepted solution]

Yes, you can have multiple queries in one SQL Procedure

proc sql;
   create table class1 as
      select * from sashelp.class;
   create table class2 as
      select * from sashelp.class;
quit;