JMP User Community

Latest Discussions

Transposing very large data table

Hi, I have a very large data file, (20+ million rows, 10 columns) that I need to transpose. Unfortunately, jmp is not capable of executing such large file quickly or efficiently. I found that jmp is able to manipulate data in text format much easily. I have tried all options of save/open as .txt but no vail.. Can someone help transposing this table either in txt format or data table (list, arra...
sgourshe

Discussions |
Jan 23, 2019 10:19 AM

10505 views | 8 replies
How to fix the y-axis range in distribution graph?

I generated 20 different distribution graphs and it has different y-axis range. I want to fix the y-axis range (0 to 80) at one time. Now I'm changing the range (0 to 80) in every graph one by one and it takes lots of time. Could you guide me how to change the range in the more easy way? Many thanks in advance!!!
JK

Discussions |
Jan 23, 2019 7:00 AM

13373 views | 5 replies
open xls data

I have a tab in xls sheet wich combines data from different xls tabs into one which I try to open via jsl for further data processing in jmp. When I use the open function the data downloaded into jmp is wrong. Either no values are copied into jmp are fake dates (1900s). However, when I use xls add in from jmp to convert table into jmp table I get the correct data. Is there a method to change the ...
SC1

Discussions |
Jan 23, 2019 6:01 AM

7279 views | 7 replies
Sample Size and Power Calculation

Hi All, I'm seeking help on how to determine the statistically correct sample to be used for my experiment.Below is the scenario and given data: Hypothesis: The new chemical Z used in process A has no significant difference in Process Sigma A.Matrix: I have 3 cells to be evaluatedCell 1: POR , Chemical XCell 2: Chemical Z1 (certain concentration)Cell 3: Chemical Z2 (certain concentration) Process ...
switzal87

Discussions |
Jan 23, 2019 1:04 AM

4633 views | 1 replies
Open file using batch script

I have a linux application that generates text data tables that we study with JMP. I'd like to be able to open these files in JMP with a hotkey. I was thinking of writing the filename to a standard location, then using a batch script to open the file in the currently-running JMP. I've tried a batch file with this: FOR /F "tokens=*" %%I IN (\\server\path\to\file\with\path\to\text\file\to\open) DO ...
BHarris

Discussions |
Jan 22, 2019 11:05 AM

4473 views | 1 replies

Previous
Next

Latest Discussions

Sample Size and Power Calculation

Hi All, I'm seeking help on how to determine the statistically correct sample to be used for my experiment.Below is the scenario and given data: Hypothesis: The new chemical Z used in process A has no significant difference in Process Sigma A.Matrix: I have 3 cells to be evaluatedCell 1: POR , Chemical XCell 2: Chemical Z1 (certain concentration)Cell 3: Chemical Z2 (certain concentration) Process ...
switzal87

Discussions |
Jan 23, 2019 1:04 AM

4633 views | 1 replies
Ternary plot and background grid issue with JMP 14

Hello,Since I moved to JMP 14 I have this issue when plotting ternary plots with Contour fill: a grid is systematically drawn with thin white horizontal and vertical lines (see captures), whatever the Color theme chosen for the Contour fill. This issue was not present in my previous JMP versions until JMP 13. Any idea to remove these thin white horizontal and vertical lines? I can't manage to remo...
dp30

Discussions |
Jan 18, 2019 1:16 PM

6044 views | 4 replies
Select Where(Contains()) Usage

I often find that the Contains() function inside the Select Where() function can be convenient. What if I would like to select all rows where a designated column contains the string "a" when it is followed by a number? For example, in a column with the values "a", "a12", and "absent", only the row with "a12" would be selected. Thanks for any tips!
twillkickers

Discussions |
Jan 18, 2019 10:33 AM

10605 views | 3 replies
How to set color scale for a contour plot

and if I have several plots by page, how to set the different scale for each of them? Thanks a lot!
jasongao

Discussions |
Jan 17, 2019 5:14 PM

3387 views | 1 replies
Get Selected Rows results in error, when using the rows

Hey,i can´t figure out, why the following results in an error: For( i = 1, i <= N Items(list), i++, item = list[i]; rows = dt << Get Rows Where( dt:foo == item ); Column(dt, "bar" )[rows] = "foobar"; );The error is: "Cannot set value for the column 'bar' because the row number (-1) is not valid.{941}" Can anyone enlighten me? Thank you!
vkessler

Discussions |
Jan 17, 2019 9:55 AM

6127 views | 5 replies

Previous
Next

Latest Discussions

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

2411 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

3110 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

3433 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2326 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3276 views | 0 replies