JMP User Community

Latest Discussions

How do I select all rows below a specific value?

Hello, Is there a way in JSL to select all rows below a specific value in a column? The tricky part is that I know what the specific value is but I won't know which row it is on or what values may fall below it in the data table. In my Example Data Table, I would like to select where Column 3 == "B" and all subsequent rows. After running the script, rows 4 through 15 should be selected. Keep in mi...
Raquel

Discussions |
Nov 29, 2018 6:21 AM

6776 views | 2 replies
How to abort script and show error message if save file fails?

Hi,I made a script that converts JMP to a csv file and saves it to network PCs using their IP address.dt = Current Data Table(); ToolID = {"G01", "G02", "G03", "G04"}; IP_add = {"10.87.123.456", "10.87.123.789", "10.87.456.789", "10.87.789.123"}; current_pref = Char( Arg( Parse( Char( Get Preferences( Export settings ) ) ), 1 ) ); Pref( Export Settings( End Of Field( Comma ), Export Table Headers(...
shaira

Discussions |
Nov 28, 2018 3:50 PM

10778 views | 5 replies
How to extract month in words from a date value & how to change the default marker for outliers?

Hi everyone.1.) How can I extract the month in words from a date value for an entire column?
Say cell # 1 has the date "03/19/2009". I would like the next column to get the month - "March", in this example.2.) Is there a way to change the default marker for outliers - like globally make the outlier markers an outlined-triangle?
Appreciate the help.
rabelardo

Discussions |
Nov 28, 2018 1:14 PM

21434 views | 8 replies
Automatically selecting outliers

I have 7000 rows, that consists of multiple batches. I am doing a distribution by batch and using the outlier box plot to look for outliers. But I have 100+ batches, is there a way to have JMP automatically select which rows are outliers?
lmaley

Discussions |
Nov 28, 2018 1:10 PM

20650 views | 24 replies
How do I use JSL to completely remove files from my hard drive?

Hi!
For example, delete path c:\1.txt completely, instead of putting it in the recycle bin.
With JSL.
Thanks!
lwx228

Discussions |
Nov 28, 2018 6:33 AM

9389 views | 3 replies

Previous
Next

Latest Discussions

How to abort script and show error message if save file fails?

Hi,I made a script that converts JMP to a csv file and saves it to network PCs using their IP address.dt = Current Data Table(); ToolID = {"G01", "G02", "G03", "G04"}; IP_add = {"10.87.123.456", "10.87.123.789", "10.87.456.789", "10.87.789.123"}; current_pref = Char( Arg( Parse( Char( Get Preferences( Export settings ) ) ), 1 ) ); Pref( Export Settings( End Of Field( Comma ), Export Table Headers(...
shaira

Discussions |
Nov 28, 2018 3:50 PM

10778 views | 5 replies
Logit Regression Help

I am trying to run a Logit Regression and it has to include a column called "validation" which is just one of two words (half the data points are word type, the other half are another) so it comes up on JMP as nominal. What do I do? Thanks. The data is attached, choice is the dependent and all of ther other variables should be the predictors (including validation column).
ryanstar123

Discussions |
Nov 27, 2018 5:51 PM

8444 views | 6 replies
transfer/share JSL with other code languages

Has anyone developed/found a way to convert/share/"compile" JSL into something usable by other languages? Here is my problem. As the developer of the initial code in R&D, I want a way to be able to give researchers code/tools that meet their needs and work with there existing analysis structure (JMP). However, some of these tools get merged into larger suites (for operations/QC, etc) where an exis...
nathan-clark

Discussions |
Nov 26, 2018 10:06 AM

5798 views | 3 replies
ANOVA fit model

hiI am comparing yield of three varieties of potatoes, variety A has 10 samples, variety B has 5 samples and varietry C has 20 samples. So sample number (replications) are not even. I want to perform ANOVA using fit model. I have created three comuns Variety, sample#, and yield.So, yield (continuous) is the response factor. In the constrct model, do I have to include only varietry (nminal) or both...
manphoolfageria

Discussions |
Nov 23, 2018 5:32 PM

3571 views | 1 replies
Shelf life Prediction of Pharmaceuticals by using Modified Arrhenius equation

Hi, Can someone help me fit this equation Ln k = Ln A - Ea/(RT) + B(%RH) in JMP file. we have a set of data as attahced. Is there any way in JMP that this data fits into the above equation adn extrapolate the value at 25°C for 2 years. Thanks in advance.
ParsaKarthik

Discussions |
Nov 23, 2018 9:18 AM

4706 views | 1 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

2561 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

3235 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

3643 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

2467 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

3443 views | 0 replies