Multiples output with proc sql

[SASdevAnneMarie]

Hello Experts,

Do you know please, if it is possible to have the multiple outputs with proc sql satement  (I mean to use the output statement).

Thank you !

[Kurt_Bremser · Accepted solution]

Creating multiple datasets in one step is the domain of the DATA step. CREATE TABLE in SQL accepts only one table name.

Maxim 14: Use the Right Tool.

[SASdevAnneMarie]

Thank you, Kurt.