You can create a new SAS, DB2, or other database management system table from your output; see Creating New Tables for details You can save the SQL query to a catalog entry of type SQL. You can save ...

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.