Using the Designer Window

Problem

You want to create SQL queries that you can use in SAS Data Integration Studio jobs. You want to build these queries in a graphical interface that enables you to drag and drop components onto a visual representation of a query. After a component is added to the query, you need the ability to open and configure it.

Solution

Use the Designer window for the SQL transformation to create, edit, and review an SQL query. You access this window when you double-click the SQL Join in a SAS Data Integration Studio job. (You can also right-click the transformation and click Open in the pop-up menu.) The window contains sections that are designed to simplify creating the SQL query and configuring its parts.

Tasks

Using Components in the Designer Window

The Designer window enables you to perform the tasks listed in the following table:
Designer Tab Tasks
Task
Location
Action
Select and manipulate an object that displays in the Diagram tab.
Navigate pane
Click the object that you need to access.
Add SQL clauses to the flow shown on the Diagram tab.
SQL Clauses pane
Double-click the clause or drop it on the Diagram tab.
Review the list of columns in the source table and the target table. Note that you can specify alphabetic display of the columns by selecting Display columns in alphabetical order.
Tables pane
Click Select, Where, Having, Group by, or Order by in the SQL Clauses pane.
Display and update the main properties of an object that is selected on the Diagram tab. The title of this pane changes to match the object selected in the Navigate pane.
Properties pane
Click an object on the Diagram tab.
Create SQL statements, configure the clauses that are contained in the statement, and edit the source table to target table mappings. The name of this component changes as you click different statements and clauses in the Navigate pane.
Diagram tab
Click SQL Join, Create, or From in the Navigate pane.
View the SAS code generated for the query.
Code tab
Click Code at the bottom of the Diagram tab.
View the log of a SAS program, such as the code that is executed or validated for the SQL query.
Log tab
Click Log at the bottom of the Diagram tab.
Last updated: January 16, 2018