Access SAS options from the File > SAS menu:
Select and import data from an SQL database on a SAS server without writing SQL statements. See Build SQL Queries in Query Builder for details.
You can also find shortcuts for SAS options on the SAS page of the JMP Starter, and there is a SAS toolbar. You can save certain settings pertaining to SAS Integration on the SAS Integration page of the Preferences window (File > Preferences). For more information about setting your SAS Integration preferences, see SAS Integration in JMP Preferences.
•
|
•
|
Macintosh supports reading and writing .sas7bdat files.
|
•
|
When you open a data set in JMP, the file opens as a data table. JMP uses SAS variable names as column names by default. To use variable labels in a specific file on Windows, select the option when you open the file (see step 5 below).
1.
|
Select File > Open.
|
2.
|
Note: SAS variable names and formats are preserved and can be saved after changes are made to the SAS data set. See Save as a SAS Data Set in Save and Share Data.
‒
|
SAS variable labels Uses the SAS variable labels (instead of variable names) as the column names in the JMP data table.
|
‒
|
SAS variable names Uses the SAS variable names (instead of the labels) as the column names in the JMP data table.
|
‒
|
Apply table and column properties from SAS 9.4 extended attributes If the SAS server supports extended attributes (SAS 9.4), includes the extended attributes when storing JMP metadata. This setting overrides the SAS 9.4 Extended Attributes preference on the SAS Integration page.
|
‒
|
Select this filter the next time this dialog is invoked Sets the default file type choice to the option that you select next to the File name list If selected, the default file type will be SAS Data Sets the next time you reach this window.
|
‒
|
Select member Lets you enter the name of a specific member, or table, for JMP to open. On Macintosh, select Member Tables > Specified and then enter the name.
|
‒
|
Open all members Opens all members, or tables, in the transport file. On Macintosh, select Member Tables > All.
|
‒
|
Save all members Saves the file as a JMP file as soon as you open it. The file is saved to the same directory where the SAS transport file was opened. On Macintosh, the option is Save all.
|
‒
|
Select Columns Tells JMP to open only certain columns from the transport file. Select the columns that you want to import from the list that appears. On Macintosh, the option is Select columns before opening.
|
7.
|
Click Open.
|
To begin, select File > SAS > Server Connections. The SAS Server Connections window shown in SAS Server Connections appears. All connections are made in this window.
1.
|
Select File > SAS > Server Connections. The SAS Server Connections window shown in SAS Server Connections appears.
|
4.
|
Click Connect.
|
If JMP is unable to establish a connection, an error message appears. Common reasons are invalid user names or passwords. If you need to update the information for the profile, see To create or modify a SAS Metadata Server profile.
5.
|
Click Close.
|
1.
|
Select File > SAS > Server Connections. The SAS Server Connections window shown in SAS Server Connections appears.
|
Note: 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.
3.
|
Click Connect.
|
Under Open Workspace Server Connections, the Workspace Server is shown as the current active connection. See Current Active Connection.
4.
|
Click Close.
|
To change the active connection, you first need to be connected to more than one server. Follow the instructions in To connect to a SAS Workspace Server (Windows only) to add two or more server connections.
2.
|
Click Set as Active.
|
3.
|
Click Close.
|
2.
|
Click Disconnect.
|
2.
|
Click Disconnect.
|
1.
|
In the SAS Server Connections window, select the SAS Server Version.
|
2.
|
Click Manage Profiles.
|
3.
|
The name of the machine that hosts the Metadata Server. (Example: myserver.mycompany.com)
5.
|
Click Save.
|
You can also connect directly to a SAS Workspace Server, instead of going through a Metadata Server.
1.
|
Select File > SAS > Server Connections. The SAS Server Connections window shown in SAS Server Connections appears.
|
2.
|
Under Establish New Workspace Server Connection, select Connect to remote SAS server on. See Open a Connection to a Remote SAS Server.
|
4.
|
Click Connect.
|
6.
|
Click OK.
|
7.
|
Click Close in the SAS Server Connections window.
|
2.
|
Click Disconnect.
|
On Windows, you can connect to a SAS mid-tier (or SAS environment) if SAS Server version 9.3 or 9.4 is selected in JMP’s preferences and your computer or JMP has been configured correctly. (SAS Server version 9.4 is the default setting in the JMP SAS Integration preferences.)
1.
|
Select File > Preferences > SAS Integration.
|
2.
|
3.
|
To connect to an environment that JMP has already detected, click Automatic discovery, and then select the URL from the list if necessary.
|
4.
|
To enter the path to the SAS environment definition file, click Manual configuration and enter the URL.
|
5.
|
Click OK.
|
1.
|
Select File > SAS > Server Connections to open the SAS Server Connections window.
|
2.
|
In the Metadata Server Connection area, select Connect to a SAS Environment.
|
If this option is not available, either your computer or JMP is not configured to find the environment. See To configure your JMP preferences for details.
4.
|
Click Connect.
|
1.
|
Select File > SAS > Server Connections to open the SAS Server Connections window.
|
2.
|
Under Establish New Connection, select Connect to SAS on this machine.
|
3.
|
Click Connect.
|
4.
|
Click Close in the SAS Server Connections window.
|
1.
|
In the SAS Server Connections window, select Local under Open Connections.
|
2.
|
Click Disconnect.
|
1.
|
Select File > SAS > SAS Query Builder.
|
‒
|
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.
|
3.
|
Click OK.
|
•
|
Extended attributes are not imported by default. To import them, modify the JMP SAS Integration preferences. Select File > Preferences (Windows) or JMP > Preferences (Macintosh). Select SAS Integration and then select On import, apply table and column properties from extended attributes.
|
To browse the data sets on the SAS server, select File > SAS > Browse Data. The Browse SAS Data window appears. See Browse SAS Data.
The window is initially populated with a list of servers the SAS Metadata Server provides (if connected). Any physical and local connections are also shown (as listed in Open a Connection to a Remote SAS Server).
When you select a data set, the Data Preview outline shows you the first ten rows and columns in the data set. See Data Preview.
Click Get Details in the Browse SAS Data window to see the size and last modification date for each data set in the library. This option helps you estimate whether your computer can process the entire data set.
To see information about a particular column in the data set, select it. The Column Details outline shows you some basic information about the data column. See Column Details.
By default, JMP specifies All rows for import.
2.
|
Click Import.
|
‒
|
‒
|
1.
|
2.
|
1.
|
In the Import Options section, select Auto-sample and specify the number of MB to import.
|
2.
|
1.
|
In the Import Options section, click Select Columns.
|
3.
|
Click Add.
|
5.
|
1.
|
Click Where.
|
3.
|
Click OK to return to the Browse SAS Data window.
|
4.
|
Click Import.
|
For information about constructing WHERE clauses and using the WHERE clause editor, see Use the WHERE Clause Editor.
3.
|
Click Execute Custom SQL.
|
Note: Your SQL is run on the selected server but is not restricted to any selected library or data set.
In the Sample Imported Data area of the Import Options outline, select the Custom random sample check box. By default, 5% of the rows are imported. To change the random sample import settings, click the Settings button.
You can set the sample size be percentage or by number of rows. To ensure that each row is sampled only once, de-select the With replacement option. To ensure that any row can be sampled and appear more than once in the imported data, select the option.
If With replacement is selected, you can specify to either add each duplicated row as a separate row or combine all duplicated rows into one row. If the second option is selected, a column is added to the table that contains a count of how many times each row was sampled.
1.
|
Select File > Open.
|
2.
|
4.
|
Click Open.
|
You must be connected to a Metadata Server to view and run stored processes. If you select File > SAS > Browse SAS Folders without such a connection, you are prompted to either make a connection or cancel your action.
1.
|
Select File > SAS > Browse SAS Folders.
|
3.
|
Select it and click Run.
|
On Windows, you can also right-click a stored process and select Copy Metadata Path. This option copies the path to the clipboard. You can then paste it into a script window to include it as a parameter for the JSL operator Meta Get Stored Process(). For more information, see the Scripting Guide.
Stored processes send reports to HTML by default, but you can select RTF or PDF instead on the SAS Integration page of the JMP preferences. Select File > Preferences (Windows) or JMP > Preferences (Macintosh) to view the JMP preferences.
Note: Use the JSL function As SAS Expr( formula ); to turn any prediction formula into an expression that can be used in a SAS Data Step. See the JSL Syntax Reference.
1.
|
Either open an existing SAS program using File > Open, or create a new SAS program. (Create a new SAS program by selecting File > SAS > New SAS Program and typing in the SAS code.)
|
2.
|
Click the Submit to SAS icon .
|
You can also right-click in the Program Editor window and select Submit to SAS. The menu item also includes the name of the active SAS server that the SAS code will be submitted to.
Write and run a JSL script that uses either the SAS Submit or SAS Submit File JSL functions. For more information about writing JSL scripts that submit SAS code, see the Scripting Guide.
If the submitted SAS code generates SAS Listing (textual) output, that output is automatically be displayed in a SAS Output window when the job is completed. If you need to view the SAS Listing output again later in the JMP session, select File > SAS > Open SAS Output Window. The SAS Output Window retains the listing output from the previous 25 submits to the active SAS server.
If the submitted SAS code contained errors, the SAS Log window for the active SAS server is automatically opened, displaying the SAS Log for the job. However, you can view the SAS Log for the most recent 25 submits to the active server at any time by selecting File > SAS > Open SAS Log Window.
1.
|
3.
|
Also, in the Show SAS Log section, you can set whether the SAS Log should be displayed Always, Never, or On Error (the default).
1.
|
2.
|
3.
|
Select the Automatically generate ODS results option.
|
4.
|
From the ODS Result Format list, select the format in which to generate the ODS results: HTML, PDF, RTF, or a JMP report.
|
5.
|
1.
|
3.
|
Select the Import generated SAS data sets into JMP option.
|
3.
|
Select File > SAS > Export Data to SAS.
|
5.
|
(Optional) To export only some of the columns in the data table, click Select Columns. See To select columns to export for details.
|
10.
|
Click Export.
|
1.
|
To export only some of the columns in the data table, click Select Columns.
|
•
|
Define an autoexec.sas file that runs a snippet of SAS code every time SAS is invoked. This creates the same librefs every time you connect to SAS. For details about autoexec.sas files, see the SAS documentation.
|