Windows supported formats are .sas7bdat and .sas7bxat.
Note: On Macintosh, select File > Open, select the data set, and then click OK.
1.
Select File > Open.
2.
(Windows only) Select SAS Data Sets from the list next to File name as shown in Open SAS Data Set.
Open SAS Data Set
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.
Note: misc and work are SAS libref names.
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.
SAS Server Connections
1.
Select File > SAS > Server Connections. The SAS Server Connections window shown in SAS Server Connections appears.
4.
Click Connect.
5.
Click Close.
1.
Select File > SAS > Server Connections. The SAS Server Connections window shown in SAS Server Connections appears.
Open a Connection to a Workspace Server
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.
Current Active Connection
4.
Click Close.
2.
Click Set as Active.
3.
Click Close.
2.
Click Disconnect.
2.
Click Disconnect.
2.
Click Manage Profiles.
3.
Click Add to add a new profile, or click Modify to change a profile’s settings.
Create or Modify a Metadata Server Profile
5.
Click Save.
1.
Select File > SAS > Server Connections. The SAS Server Connections window shown in SAS Server Connections appears.
Open a Connection to a Remote SAS Server
4.
Click Connect.
6.
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.
Select I want to connect to a SAS Environment and then click Configure.
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.
5.
1.
Select File > SAS > Server Connections to open the SAS Server Connections window.
2.
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.
2.
Click Disconnect.
1.
Select File > SAS > SAS Query Builder.
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.
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.
Browse SAS Data
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.
Column Details
By default, JMP specifies All rows for import.
2.
Click Import.
Import Options
1.
In the Import Options section, select First x rows only and specify the number of rows to import.
1.
In the Import Options section, select Auto-sample and specify the number of MB to import.
Select Columns
3.
Click Add.
1.
Click Where.
3.
Click OK to return to the Browse SAS Data window.
4.
Click Import.
Custom SQL
3.
Click Execute Custom SQL.
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.
Sampling Settings
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.
Select SAS Data Sets from the Files of type list.
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.
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.
SAS Code Submission Example
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.
1.
Select File > Preferences (Windows) or JMP > Preferences (Macintosh).
3.
In the Show SAS Log section, select JMP Log rather than Separate Window.
1.
Select File > Preferences (Windows) or JMP > Preferences (Macintosh).
SAS Submit Options in Preferences
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.
1.
Select File > Preferences (Windows) or JMP > Preferences (Macintosh).
3.
Select the Import generated SAS data sets into JMP option.
3.
Select File > SAS > Export Data to SAS.
Export Data to SAS
10.
Click Export.
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.