topic Multiple select/sql statements in PROC SQL in New SAS User

Multiple select/sql statements in PROC SQL

jffeudo86 — Fri, 31 May 2019 14:16:39 GMT

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.

Re: Multiple select/sql statements in PROC SQL

PaigeMiller — Fri, 31 May 2019 14:19:50 GMT

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;

Re: Multiple select/sql statements in PROC SQL

PeterClemmensen — Fri, 31 May 2019 14:20:17 GMT

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;