Using the Code Tab

You can click the Code tab to view the SQL statements that are generated by the data preparation expressions on the Design tab.
The Code tab can also be used to enter custom code.
  • The Preprocess and Postprocess views enable you to enter SAS statements that are run before and after the query runs.
  • The All Code view shows the generated SQL statements. You can click the Unlock for manual editing button to unlock the view so that you can manually edit all of the SAS statements for the query. After you have unlocked the view, the button icon changes to Unlocked for manual editing.
After you have unlocked the view, you cannot continue using the Design tab to edit the query, and the Preprocess and Postprocess views are disabled. However, if you have not saved your changes to the code, you can click the Undo button to be able to use the Design tab.