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 and table properties as extended attributes in a SAS 9.4 .sas7bxat file.
To use an existing connector
1. Select File > Export.
2. Select SAS and click Next.
3. In the Export Data to SAS window:
a. To select the columns to include in the data export, click Select Columns.
b. (Optional) Rename the file.
c. (Optional) To export all rows, select Ignore ‘excluded‘ row state (export all rows).
d. (Optional) To save SAS variable names or SAS formats, select the Preserve SAS variable names or Preserve SAS formats check boxes.
e. To create a new data connection, click New Connection.
4. In the Select SAS Data Connector window:
a. Select a data connector.
b. Click Connect.
c. If you are prompted, enter your login credentials.
d. Click OK.
5. Click Export.
To create a new connector
1. Select File > Export.
2. Select SAS and click Next.
3. In the Export Data to SAS window:
a. To select the columns to include in the data export, click Select Columns.
b. (Optional) Rename the file.
c. (Optional) To export all rows, select Ignore ‘excluded‘ row state (export all rows).
d. (Optional) To save SAS variable names or SAS formats, select the Preserve SAS variable names or Preserve SAS formats check boxes.
e. To create a new data connection, click New Connection.
4. In the Select SAS Data Connector window:
a. Click New.
b. In the Data Connector Editor window, specify the connector details.
c. Click Connect.
d. If you are prompted, enter your login credentials.
e. Click OK.
5. Click Export.
To use an existing connector
1. Select File > Export.
2. Select SAS and click Next.
3. In the Export Data to SAS window:
a. To select the columns to include in the data export, click Select Columns.
b. (Optional) Rename the file.
c. (Optional) To export all rows, select Ignore ‘excluded‘ row state (export all rows).
d. (Optional) To save SAS variable names or SAS formats, select the Preserve SAS variable names or Preserve SAS formats check boxes.
e. To create a new data connection, click New Connection.
4. In the Select SAS Data Connector window:
a. Select a data connector.
b. Click Connect.
c. If you are prompted, enter your login credentials.
d. Click OK.
5. Click Export.
To create a new connector
1. Select File > Export.
2. Select SAS and click Next.
3. In the Export Data to SAS window:
a. To select the columns to include in the data export, click Select Columns.
b. (Optional) Rename the file.
c. (Optional) To export all rows, select Ignore ‘excluded‘ row state (export all rows).
d. (Optional) To save SAS variable names or SAS formats, select the Preserve SAS variable names or Preserve SAS formats check boxes.
e. To create a new data connection, click New Connection.
4. In the Select SAS Data Connector window:
a. Click New.
b. In the Data Connector Editor window, specify the connector details.
c. Click Connect.
d. If you are prompted, enter your login credentials.
e. Click OK.
5. Click Export.