JMP User Community

Latest Discussions

Importing an Excel Worksheet using JMP on MAC

So maybe I'm just tired on a Friday afternoon, but I'm seeing a strange problem when scripting the Open function using JMP (14.2) on MAC. Here is a simple script that does what you would expect - it creates a JMP table containing the contents of the sheet1 of the test spreadsheet. Open( "/Users/docs/test.xlsx", Worksheets( "sheet1" ) ) But when I call it from a class method it launche...
David_Burnham

Discussions |
Feb 9, 2019 11:03 AM

4753 views | 2 replies
Need help understanding parameters and table variables

Hi! I have a practical problem that I think I could solve using some kind of parameter or table variable.Let's say I have multiple processes, each having a row. Which are characterized by few parameters, A, B, C... Those are columns.Let's say for each parameter I have a threshold after which it is considered risky. So I created columns bit-A, bit-B etc. If parameter is grater than some number, I g...
miguello

Discussions |
Feb 8, 2019 3:35 PM

5793 views | 2 replies
Control indicator column options using JSL

Hi All, If I would like to make a multi-response column into indicator columns, the Cols->Utilities->Make Indicator Columns provide column name and missing value options to construct desired columns. How should I contral those two options using JSL?I have an example from Scripting indexNames Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Animals.jmp" ); dt << Make Indicator Columns( columns( {:sea...
Tzu-Chun

Discussions |
Feb 8, 2019 1:28 PM

4944 views | 2 replies
Is there way to search the files including the subfolders, instead of Files In Directory(path)"

The command "Files in Directory(path)" only search files listed in the path,I'd appreciate if anyone could advise on how to search the subfolders under the path directory Thanks!
wu

Discussions |
Feb 8, 2019 11:49 AM

4822 views | 1 replies
Multi-User Access

I'm working on a solution which will live on a network drive, to be accessed by multiple users asynchronously. Specifically, I have several "database" tables that users will add rows to, where the rows then contain links to their full submitted datatable. Is there any built-in way to manage file access permissions in a situation like this? I want to avoid a situation where a user opens the "datab...
DavidLeber

Discussions |
Feb 8, 2019 9:30 AM

5000 views | 1 replies

Previous
Next

Latest Discussions

DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

3269 views | 0 replies
JMP and Dynamic SQL queries

Does anyone know if JMP supports some form of Dynamic SQL queries? I want to do some special querying that is easier to dynamically generate the sql query than directly writing it.
cookiedough

Discussions |
Feb 6, 2019 4:50 AM

3655 views | 2 replies
How to re-size a report table in JSL?

For example, I have made a report from a table as shown below:op1 = tbl1 << Get As Report; But the default display for the report table is too small (yes, I can use the scroll bars to move around). Is there any way in JSL so that I can re-size or maximize the display window for the report? I tried the followings, but none works :-(. <<Set Window Size
<<Maximize Window<<Maximize Display<<Get Max Si...
zxu11

Discussions |
Feb 3, 2019 6:49 PM

4480 views | 3 replies
Huge DF denominators for repeated measures ANOVAs with JMP 14

I used to run repeated measures ANOVAs with JMP 13 with no proglems. But now I got JMP 14 and ran an ANOVA with the same data and somehow got "4326" as a DF Den under "Test Denominator Synthesis". This used to be "42" with JMP 13, and ovbiously the new F ratio got so much larger. I do not think there is anything different I did (data, how to set up), other than I am now using JMP 14 instead of ...
mu

Discussions |
Feb 1, 2019 8:45 AM

11822 views | 15 replies
How to change mosaic plot graph order?

Hey Folks, I was just wondering how to change the order of the data displayed in the mosaic charts. In the picture below, say I would like to change the order of the data to be displayed as blue at the top, or orange goes to the bottom. Thanks in Advance, Thomas
ThomasLovesRedV

Discussions |
Jan 31, 2019 9:28 PM

5328 views | 1 replies

Previous
Next

Latest Discussions

DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

3269 views | 0 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

2939 views | 0 replies
I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2226 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

2921 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3231 views | 0 replies