1

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.

1201ProgramAlarm
  • 32,384
  • 7
  • 42
  • 56
Ray1076
  • 23
  • 1
  • 4

1 Answers1

2

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.

Len Greski
  • 10,505
  • 2
  • 22
  • 33
  • 1
    Echoing the use of the free trial route. The format appears to be proprietary and most solutions outside of R seem to be controlling SAS/JMP via Windows DCOM or converting to another format (and all the R solutions seem to be convert to another format so they're readable or use the bridge inside SAS/JMP to use R functions). – hrbrmstr Sep 05 '18 at 11:45
  • Thank you very much for 1) confirming that there is no direct import option, and 2) providing the other suggestions. I have installed the trial version of JMP and I'm converting the needed files to CSV for import into R. – Ray1076 Sep 17 '18 at 11:55