Using JMP • Save and Share Data • Save and Share Data Tables
Previous
 • 
Next
Save and Share Data Tables
JMP saves data tables in the formats listed in Supported File Types for Saving Data Tables.
Here are the basic steps for saving a data table:
•
On Windows, select File > Save As to save in multiple formats.
•
On Macintosh, select File > Save As to save as a JMP file (.jmp). Select File > Export to save in Text (.dat), Microsoft Excel (.xls or .xlsx), SAS Transport (.xpt), and SAS Data Sets (.sas7bdat) formats.
Note: To save a data table as a journal or layout, select Edit > Journal or Edit > Layout and then File > Save As.
Supported File Types for Saving Data Tables 
File Type(s)
Extension
OS Availability
JMP Data Table
.jmp
All
Excel Workbook
.xls
.xlsx
All
Text Export File
.txt
All
Comma-delimited file
.csv
Windows
Tab-delimited file
.tsv
Windows
SAS Data Set
.sas7bdat
All
SAS Data Set with Extended Attributes
Note: JMP can save column properties and table properties as extended attributes in a SAS 9.4 .sas7bxat file. Select File > Save As, select the SAS Data Set file type, and then select the check box for saving extended attributes. JMP names the file with the .sas7bxat extension. The SAS Integration preferences also include this option, which is off by default.
.sas7bxat
Windows
SAS Transport File
.xpt
.stx
All
Macintosh
dBASE Files
.dbf, .ndx, .mdx
Windows
You can also save files for types that have a corresponding ODBC driver. See Save Data Tables to a Database, for details.
Tip: The maximum length of the data table’s name depends on your computer’s operating system. See your operation system documentation for details.
Note: JMP tries to save any modified files when a crash is detected.
Save as a Microsoft Excel File
You can save a JMP data table in Microsoft Excel format (.xls or .xlsx). Data is saved in one worksheet named after the data table. On Windows, data is split among several in worksheets when the number of columns or rows exceeds the number that Microsoft Excel supports.
Data table cell colors are maintained when you export a data table as a Microsoft Excel .xlsx file. Hidden data and excluded data are also included. Most formatting and formulas are not exported to Excel format.
Note: The maximum length of the Excel filename is determined by your computer’s operating system.
Windows
1.
Select File > Save As.
2.
Select Excel Workbook (*.xlsx, *.xls).
3.
Enter a name for your file in the File Name box.
4.
Click Save.
Macintosh
1.
Select File > Export.
2.
Select Excel and select the format.
3.
Click Next.
4.
Enter a name for the file in the Save As box.
5.
Click Export.
Save as a CSV File
JMP can convert data from a JMP data table to a comma-separated values (CSV) file. To save a data table as a CSV file:
1.
With the specific data table open in JMP, select File > Save As.
2.
Select CSV (Comma delimited) (*.csv) from the Save as type drop-list.
3.
Enter the File name.
4.
Select the location for the CSV file.
5.
Click Save.
Save as a Text File
JMP can convert data from a JMP data table to standard text format with rows and columns. To save a data table as a text file, follow the steps below based on your operating system and how you want to save the file.
Note: When importing text data, columns that contain image data must be converted to Expression column property in order to reveal the image. SeeColumn Properties, for details.
Text formatting options are:
•
Export Column Names to Text File To save column headings in the first line of text, and to save labels or header information with the data, select Export Table Headers.
•
End of Field Select the radio button next to the character that marks the end of a field (or cell). Select Other and enter a character if the appropriate character is not listed.
•
End of Line Select the radio button next to the character that marks the end of a line (or row). Select Other and enter a character if the appropriate character is not listed.
Note: If double quotation marks are found when importing text data, the delimiter rules change, and JMP looks for an end double quotation mark. Other text delimiters, including spaces embedded within the quotation marks, are ignored and treated as part of the text string.
Windows
1.
Select File > Save As.
2.
Select Text Export File from the Save as type list.
3.
Click the Options button and specify end-of-line and end-of-field characters, and choose whether to export column headings as text.
4.
Click OK.
5.
Click Save.
An alert appears regarding loss of formulas, formatting information, and other metadata.
6.
Click Yes.
Macintosh
1.
Select File > Export.
2.
Select Text and click Next.
3.
Enter a name for the file in the Save As box and change the extension to .txt.
4.
Specify end-of-line and end-of-field characters, and choose whether to export column headings as text.
5.
Click Export.
Save as a SAS Transport File
You can save a JMP data table in SAS transport file format. JMP replaces spaces in filenames and column names with underscores, converts column headings to uppercase SAS variables, and makes other changes to follow the transport file specifications.
When you save the data table as a transport file, you can opt to append it to an existing transport file. When you reopen the transport file in JMP, the two data tables open in separate windows.
Note: The maximum length for SAS transport file names is 8 characters. JMP warns that characters beyond that limit are omitted.
Windows
1.
Select File > Save As.
2.
Select SAS Transport File from the Save as type list.
3.
(Optional) Append the data table to an existing SAS transport file. Select the file to which you want to append the data table, and then click the Save arrow. Select Append To, and then click Yes to replace the selected data table.
An alert appears regarding loss of formulas, formatting information, and other metadata.
Note: Images in Expression columns cannot exceed 200 characters, otherwise they are not supported.
4.
Click Yes.
Alerts appear regarding other SAS format modifications.
5.
Click OK on each alert.
Macintosh
1.
Select File > Export.
2.
Select SAS Transport.
3.
(Optional) To append the data table to an existing SAS transport file, select the Append check box.
4.
Click Next.
5.
Do one of the following:
‒
If you chose to append the data table, select the file to which you want to append the data table and click Append.
‒
Enter a name for the file in the Save As box, and then click Export.
Alerts appear regarding SAS format modifications.
6.
Click OK on each alert.
Save as a SAS Data Set
You can save data tables as SAS version 7 and higher data sets. JMP writes columns as SAS variables, writes rows as SAS observations, and makes other changes to follow the SAS data set specifications.
When you export data to a SAS data set, JMP date columns become SAS date values with the appropriate SAS format.
On Windows, JMP can save column properties and table properties as extended attributes in a SAS 9.4 .sas7bxat file. The option is available in the Save JMP As window and in the SAS Integration preferences.
Windows
1.
Select File > Save As.
2.
Enter a name for your file in the File Name box. The maximum length for the filename is 32 characters. JMP warns that characters beyond that limit are omitted.
3.
Select SAS Data Set from the Save as type list.
4.
(Optional) To save SAS variable names or SAS formats, select the Preserve SAS column names or Preserve SAS formats check boxes.
5.
(Optional) To store JMP metadata as extended attributes for SAS 9.4, select Store table and column properties in SAS 9.4 extended attributes. JMP automatically assigns the .sas7bxat file extension.
6.
Click Save.
An alert appears regarding loss of formulas, formatting information, and other metadata.
7.
Click Yes.
8.
If other alerts appear, click OK on each alert.
Macintosh
1.
Select File > Export.
2.
Select SAS and click Next.
3.
Enter the filename and select export options.
‒
To avoid exporting rows that have the Excluded row state, select Honor Excluded Rows. The other options are described in the preceding section.
Save Data Tables to a Database
You can save a data table to any database on your system that has a compliant ODBC (Open Database Connectivity) driver.
1.
First, connect to the database. See To add a new database connection.
2.
Select File > Database > Save Table.
The Database Save Table Window
3.
In the Connections box, highlight the name of the database to which you want to save the file (shown in The Database Save Table Window). The Connections box contains a list of databases to which your system is connected.
4.
From the JMP data table to be saved menu, select the open JMP data table that you want to save to the database.
5.
In the Save to database table box, enter the name that you want the table to have when you save it in the database.
6.
Click Save Table.
To add a new database connection
1.
Click Connect.
2.
Select the data source that you want and click OK. Or, to create a new source, click the New button (Windows) or Add button (Macintosh).
Depending on which data source you select (and which database drivers you have installed on your computer), you might be presented with a variety of windows. Use them to create the database source.
3.
Select the database to which you want to save the file.
Replace a Database with a Data Table
To replace a database with a data table:
1.
First, connect to the database. See To add a new database connection.
2.
Select File > Database > Save Table.
3.
In the Connections box, select the name of the database to which you want to replace the file. The Connections box contains a list of databases to which your system is connected.
4.
In the Schemas - Tables box, select the database table that you want to replace.
Note: Remember the name for the database table. You will use this same name for the replacement database table.
5.
Click Drop Table.
The database table is deleted from the database.
6.
From the JMP data table to be saved list, select the JMP data table that you want to save to the database.
7.
In the Save to database table box, type the name for the deleted database table.
8.
Click Save Table.
The data table is saved to the database.
9.
Click Disconnect.
10.
Close the Save Database Table window.
E-mail a Data Table
On Windows, you can e-mail a JMP data table by selecting File > Send. Your default e-mail application opens with the data table file attached to a new e-mail.