Questions tagged [sas-jmp]

JMP is a "Data Discovery" tool from SAS Institute. It is used for combining advanced data visualization techniques with powerful statistical tools.

JMP is a software product offered by SAS Institute that, in contrast to base SAS software, is focused on data visualization. While it has much of the same statistical power of SAS and is easily linked to various SAS products, its focus is on the visual. Producing graphs easily that allow you to see trends in your data, it complements the more numbers-focused base SAS offering and is used across all major industries.

JMP is pronounced "Jump", intended to evoke the idea of making a 'jump' in understanding by seeing your data in a visual manner.

The product website is jmp.com, and the documentation can be found on their support site.

58 questions
11
votes
5 answers

NumPy or SciPy to calculate weighted median

I'm trying to automate a process that JMP does (Analyze->Distribution, entering column A as the "Y value", using subsequent columns as the "weight" value). In JMP you have to do this one column at a time - I'd like to use Python to loop through all…
Car
  • 337
  • 2
  • 4
  • 14
6
votes
1 answer

How do I make nested x-labels like a JMP variability plot, but using ggplot2

I love the JMP variability plot. (link) It is a powerful tool. The example the plot has 2 x-axis labels, one for part-number and one for operator. Here the JMP variability plot displays more than 2 levels of variables. The following splits by oil…
EngrStudent
  • 1,924
  • 31
  • 46
6
votes
2 answers

How to call Python script from SAS JMP environment using jsl script

I would like to run python script from SAS JMP environment using JSL. What are the options?
Felix
  • 1,539
  • 8
  • 20
  • 35
4
votes
3 answers

How to call a *.jsl script from python script

I have a python script running. I want to call *.jsl script in my running python script and want to make use of it's output in python. May I know how can I do that?
Akshay
  • 833
  • 2
  • 16
  • 34
3
votes
1 answer

getting underlying OLE object identity for win32com automation objects

Most built-in Python data types and libraries make a point of returning the same object (a is b, not just a==b) even if you ask for it in different ways. A very simple example: list = [ "foo", "bar", {"name": [1,2,3]} ] a = list[-1]["name"] b =…
Dan Lenski
  • 76,929
  • 13
  • 76
  • 124
2
votes
2 answers

JSL Connection to SQL Server Express Setup DSN

I am trying to automate JSL script and I need to update some records from SQL Server using JMP JSL Script. I have found below connection string, but I am not sure how to use this. Open Database("DSN=ODBC…
kuls
  • 48
  • 6
2
votes
0 answers

select control group when using dunnet's method in c# and JMP

I am trying to automate calculation of oneway analysis with dunnet's method but I am encountering below pop up after calling the last line of code. I need to automatically select the control group so calculation will proceed. If anyone has knowledge…
Jervs
  • 344
  • 1
  • 12
2
votes
0 answers

JMP cannot read SAS outout file from R

This is a troubleshooting question. This might seem weird but I was told I had to take a data set from R and output it into a SAS file in order for someone else to work with it. I used write_sas(faithful, "faithful.sas7bdat") which utilizes the…
user9842212
2
votes
1 answer

How to read JMP *.jmp file with Python Pandas into Pandas dataframe

I am struggling to read SAS JMP files with Pandas read_csv function into Pandas dataframe. Does anyone have experience with this type of data file? What is the most efficient way?
Felix
  • 1,539
  • 8
  • 20
  • 35
2
votes
1 answer

select random ~100 million rows of billions

I'm a little compute-constrained because I don't want to kill the database or bandwidth while pulling for hours. my current query is something like this: SELECT TOP (100000000) mycolumns FROM mydb WHERE lower_control_limit> value1 AND…
EngrStudent
  • 1,924
  • 31
  • 46
2
votes
1 answer

Creating a new column in JMP using an if condition from another column

I am very new in JMP so I am still feeling around. I want to create a new column called "Status" in JMP. This status is character and depends on the value of the column "Grade". If the value of the entry in column "Grade" is zero, the value of the…
schrodingerscat
  • 189
  • 1
  • 3
  • 15
2
votes
1 answer

Vim Syntax file: defining keywords to ignore whitespace

I would like to create a vim syntax file where either: White space is included in keywords. White space is ignored in keywords. Either would work for my purpose, which is to create a JMP scripting language (JSL) syntax file. In JMP, whitespace is…
Caleb
  • 3,839
  • 7
  • 26
  • 35
1
vote
0 answers

Converting jsl script file

Please correct me if I'm wrong beginner user here from SAS. Currently I have a working script from jmp(.jsl) and it's logic is more on query related and I am just wondering if there is a possibility or features for sas that can import the jmp,…
Syntax Rommel
  • 932
  • 2
  • 16
  • 40
1
vote
1 answer

Reading .jmp files with Python on a Mac

Apparently pandas.read_sas can only read XPORT or SAS7BDAT format SAS files while Dispatch from wind32com.client can read .jmp format but only on windows. So is there a straightforward way to read in JMP files with Python on a Mac?
jmdeamer
  • 337
  • 2
  • 16
1
vote
1 answer

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…
Ray1076
  • 23
  • 1
  • 4
1
2 3 4