Considerations for Manually Editing Code

When you unlock the Code view for manual edits, you can choose the library that you use for input tables. Open the Query Properties panel, select the Input library field, and click to select a library.

The code editor enables you to complete an SQL SELECT statement. For programmers that are familiar with the SQL procedure, the SELECT statement is automatically enclosed in the SQL procedure statement and terminated with a QUIT statement.

You do not need to supply the PROC SQL statement or the QUIT statement. Do not enter semicolons in the code editor.

You can enter CASE statements, IF...THEN...ELSE statements, and any functions that can be used in the SQL procedure. Keep in mind that you can click the button periodically to validate your code.

Specify the output table and library on the Query Properties panel just as you would if you were using the Design view.