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)	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 (.sas7bxat) 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.	Windows
SAS Transport File (.xpt,.stx)	All
JSON (.jsn)	All

You can also save files for types that have a corresponding ODBC driver. See Save Data Tables to a Database, for details.

Notes:

•

The maximum length of the data table’s name depends on your computer’s operating system. See your operation system documentation for details.

•

JMP tries to save any modified files when a crash is detected.