You can enter an SQL query in the SQL Editor window if you already know the libref or creator, table, and column names that you want to use. The SQL Editor window is a complete editor with the ...

Select OK to save your query as an entry in SASUSER.PROFILE and to return to the SQL QUERY window. Select Goback to return to the SQL QUERY COLUMNS window. Saving Several Queries: You can save more ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way?