Create a Data Query

To create a data query:
  1. On the menu bar, click Filethen select New Data Query.
  2. Drag and drop tables from the SAS Folders tree onto the workspace.
  3. Select the columns that you want to include in the data query by clicking on the column names in the original tables in the workspace.
  4. Make other optional changes. For more information about optional changes, see Cheat Sheet for Data Queries.
  5. Click the Outputs tab, and specify the following:
    • In the Table field, specify a unique name for the output table or choose an existing output table to overwrite. This is the name of the file that you will use to create reports and explorations.
    • In the Location field, specify a folder where you want the data query to appear. The My Folder folder is private. Only you can use the data that you save to My Folder. If you want the data query to be accessible to others, save it to the Shared Data folder.
    • In the Library field, specify the library where the data query will be loaded. Be sure to choose a LASR library if you want to use the data query in reports or explorations. For more information about libraries, see SAS Visual Analytics 7.3: User’s Guide.
  6. Click Save to save. The Save As dialog box appears.
  7. Specify a name and location for the data query, and then click Save.
  8. Click Preview or Run query, and select Run to run the data query.
Copyright © SAS Institute Inc. All rights reserved.