Use 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.
You can also use the Code tab to enter custom code.
  • The Preprocess and Postprocess views enable you to enter SAS statements that are run before and after the data query runs.
  • The All Code view shows the generated SQL statements. Click the Unlock for manual editing button to unlock the view so that you can manually edit all of the SAS statements for the data 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 data 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.
Copyright © SAS Institute Inc. All rights reserved.