rimportsas-jmp

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.


Solution

  • 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.