Save as a SAS Data Set

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Save and Share Data • Save and Share Data Tables • Save as a SAS Data Set

For the latest version of JMP Help, visit JMP.com/help.

•

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.

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.

An alert appears regarding loss of formulas, formatting information, and other metadata.

7.

8.

If other alerts appear, click OK on each alert.

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.

•

Help created on 3/19/2020