SAS Query Builder is the preferred method for selecting and importing data from a SAS server. You can preview the data before importing it into a data table. You can also save the queries to modify and run later or to reference in a JSL script.
SAS Query Builder provides an alternative to opening SAS data sets with the File > SAS > Browse Data feature.
To open a SAS data set with SAS Query Builder, follow these steps:
1. Select File > SAS > SAS Query Builder.
2. In the Connect to SAS Server window, select a Metadata server or a remote server.
– To connect to a Metadata server that you have already set up in JMP, select the server from the Connect to metadata-defined SAS server list.
Connect to all available libraries is selected by default based on the SAS Integration preferences. This option connects metadata-defined SAS libraries automatically across all JMP sessions. When the Workspace Server contains a large number of metadata-defined SAS libraries, consider deselecting this option to speed up your connection to the server.
– To add or configure a Metadata server, click Manage Profiles and follow steps in To create or modify a SAS Metadata Server profile.
– To connect to a remote server, enter the machine name and the port number. Your SAS Metadata Server administrator should have this information.
3. Click OK.
The SAS Query Builder window appears.
For more information about using Query Builder, see Build SQL Queries in Query Builder.
Notes:
• All Query Builder queries run in the foreground.
• Extended attributes are not imported by default. To import them, modify the JMP SAS Integration preferences. Select File > Preferences (Windows) or JMP > Preferences (macOS). Select SAS Integration and then select On import, apply table and column properties from extended attributes.
• SAS Query Builder does not support local server connections.