LIBNAME Statement for the JMP Engine

Associates a libref with a JMP data table and enables you to read and write JMP data tables.

Valid in:	Anywhere
Category:	Data Access
See:	Base SAS LIBNAME Statement

Syntax

Details

Examples

Example 1: Using the LIBNAME Statement to Read a JMP Data Table

Example 2: Reading and Sorting a JMP Data Table

Syntax

LIBNAME libref JMP ‘path’ <FMTLIB=libref.format-catalog>;

Arguments

libref: is a character constant, variable, or expression that specifies the libref that is assigned to a SAS library.

Range:1 to 8 bytes

path: is the physical name for the SAS library. The physical name is the name that is recognized by the operating environment. Enclose the physical name in single or double quotation marks.

FMTLIB=libref.format-catalog

specifies where the formats are stored when a JMP data table is read and where the formats come from when a JMP data table is created.

Requirement:The library that is specified in the FMTLIB argument must be a SAS data set LIBNAME statement.

Example:

libname inv jmp "." fmtlib=seform.formats;
libname seform '.';
   data work.mine;
   set inv.suri2011;
run;

Details

A JMP file is a file format that the JMP software program creates. JMP is an interactive statistics package that is available for Microsoft Windows and Macintosh. For more information, see the JMP documentation that is packaged with your system.

A JMP file contains data that is organized in a tabular format of fields and records. Each field can contain one type of data, and each record can hold one data value for each field.

Base SAS supports access to JMP files. You can access JMP files by either of these two methods:

the IMPORT and EXPORT procedures and the Import and Export Wizard without a license for SAS/ACCESS Interface to PC Files

For more information, see SAS/ACCESS Interface to PC Files: Reference.
the LIBNAME statement for the JMP engine

Examples

Example 1: Using the LIBNAME Statement to Read a JMP Data Table

This example reads and prints five observations from the bank JMP data table.

libname b jmp 'c:/temp/national';
proc contents data=b.bank(drop=edlevel id age);
run;
proc print data=b.bank(obs=5 drop=edlevel id age);
run;

Example 2: Reading and Sorting a JMP Data Table

This example reads a JMP data table, sorts it, and stores it in a SAS data set. The formats stored on the JMP data set are put in a.formats.

libname a 'c:/temp/field';
libname b jmp '.' fmtlib=a.formats;

proc sort data=b.cars out=a.sorted;
   by category_ic;
run;