Ray1076
Ray1076

Reputation: 23

Import jmp file into r

I'm looking for a method to directly import a JMP file ("filename.jmp") into R. So far, all I can find are suggestions to first convert the JMP file to another format (either xpt, csv, etc.) and then import that new file into R.

Does anyone know of a method or way to import a JMP file without converting it first to another format?

My JMP application license has expired which is why I want to import these files into R.

Upvotes: 1

Views: 5356

Answers (2)

user2558368
user2558368

Reputation: 41

One can use Julia language package JMPReader.jl to import jmp file into R

install.packages("JuliaCall")
library(JuliaCall)
julia_setup(installJulia = TRUE)
julia_install_package_if_needed("JMPReader")
julia_library("JMPReader")
df <- julia_call("readjmp", "filename.jmp")

Upvotes: 2

Len Greski
Len Greski

Reputation: 10855

As of September 2018 there is no R function that reads JMP files. foreign::read.xport() and Hmisc::sasexport.get() work with SAS export files. The haven package can be used to read SAS files, but not JMP files.

A nice summary of import and export approaches in R is included in the rio package vignette.

A hack would be to install the 30 day trial version of JMP, convert all the data files you need to read in R to SAS data sets, and then use haven::read_sas() to read the data into R.

Alternately, one could use JMP to save the files as CSV files, per this help reference on the JMP support website, and then use read.csv() or readr::read_csv()` to read the data in R.

Upvotes: 3

Related Questions