Import Your Data

JMP Support 800.450.0135 (US)

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

Using JMP • Import Your Data

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

•

Import Your Data

Create Data Tables

This chapter covers the following topics:

•

How to import data into JMP, such as text files, SPSS files, and SAS data

•

How to transfer Excel data into a JMP data table

•

How to read in real-time data

•

How to create a new data table

Figure 3.1 Importing a Text File

Contents

About Importing Data to JMP

Import Microsoft Excel Files

Preview and Import the Microsoft Excel Data

Import a Microsoft Excel File Directly

Import Data from SAS

Java Runtime Environment (JRE) Requirements

SAS Menu Options

Import SAS Data Sets

Create SAS Transport Files in SAS

Open SAS Data Sets with SAS Query Builder

Open SAS Data Sets through a SAS Server

Using SAS Extended Attributes to Import Metadata

Run Stored Processes

Submit SAS Code

Generate ODS Results

Retrieve Generated SAS Data Sets

Build SQL Queries in Query Builder

Connect to a SQL Database

Select Tables from a SQL Database

Build the SQL Query

Save and Run the Query

Open the Selected Data in JMP

Query Builder Red Triangle Options

Write SQL Statements in Query Builder

Import Data from a Database

Connect to a Database

Open Data from a Database

Write SQL Statements to Query a Database

Structured Query Language (SQL): A Reference

Import Text Files

Text Import Wizard Options

Open a Text File in a Text Editing Window

Import Text from the Script Editor

Import Multiple Files

Import Data from the Internet or a Remote Computer

Import SPSS Files

Import Triple-S Survey Data

Import HDF5 Data

Import JSON Files

Import Data from MATLAB

Import Data from R

Import Data Using the Excel Add-In

Transfer Excel Data to a JMP Data Table

About the JMP Add-In for Excel

Uninstall the Excel Add-In

Create New Data Tables

•

Help created on 3/19/2020