JMP User Community

Latest Discussions

Read/omit particular columns from a .csv file

Hi,I would like to read in particular columns from a .csv file. The .csv files (which I currently read into jmp and concatonate) have hundreds of columns and hundreds of thousands of lines so the time to read the files into JMP becomes very large and also the JMP file becomes so big that it eventually freezes. As not all of the columns in the CSV are required for analysis I was wondering if a JSL ...
David_Morrow

Discussions |
Dec 19, 2018 8:30 AM

8998 views | 5 replies
JMP 14.1 Excel Add-in checkbox missing during installation

In previous versions of JMP, during install there was checkbox to add the JMP add-in to excel. During the 14.0 and 14.1 installation this checkbox was not an available option. Does anyone know why it's missing? Is there a way to install it manually?

Thanks
meye1474

Discussions |
Dec 19, 2018 7:54 AM

8268 views | 2 replies
Parse a column formula and swap out parameters for column references

I'm writing a script that will allow users to select one of the fit models in Non-linear platform. Save the parameterized version out to the data table and then take the parameters and replace them with column references. So how to detect the parameters in the equation, change them and insert the whole thing back into the column as a formula. In general I want to parse all arguments of a formula, ...
pauldeen

Discussions |
Dec 18, 2018 9:21 AM

3200 views | 2 replies
How can I run a script when exits JMP?

Hi, There is a way to run a script at start up. However, what should I do if I would like to run a script when exits JMP?The following code is an idea for doing that, but it didn't work in JMP.win=window("Home Window"); win<<on close( new window("Goodbye :)", <<modal, text box("Thanks for using JMP") ) );Any thoughts are appreciated. Best.
Tzu-Chun

Discussions |
Dec 17, 2018 12:36 PM

7776 views | 4 replies
"Points Spread" Function: Order of Points

Hello JMP Community, I am using the Points Spread function in the Fit Y by X platform for oneway analysis. It seems that, by default, the points are spread in reverse order of the order of data in the data table. Meaning, for each X-axis variable, the points are spread from highest row number to lowest row number (left to right). Why is this, and can I change the order of the points in this platfo...
JMPJenna

Discussions |
Dec 17, 2018 11:49 AM

4638 views | 1 replies

Previous
Next

Latest Discussions

Read/omit particular columns from a .csv file

Hi,I would like to read in particular columns from a .csv file. The .csv files (which I currently read into jmp and concatonate) have hundreds of columns and hundreds of thousands of lines so the time to read the files into JMP becomes very large and also the JMP file becomes so big that it eventually freezes. As not all of the columns in the CSV are required for analysis I was wondering if a JSL ...
David_Morrow

Discussions |
Dec 19, 2018 8:30 AM

8998 views | 5 replies
how to compare the shape of curves vs a baseline in JMP?

Hi there We are trying to evaluate the differences between measured data against an ideal baseline; in this case we're comparing the shape / magnitdue / quality of force displacement curves. We've in the past compared the various slopes, peaks and valleys to do this, but are finding this doesnt capture all the variation we are seeing. Is there a way to compare the entire "shape" of one curve a...
abdulj

Discussions |
Dec 14, 2018 10:03 AM

13859 views | 9 replies
Tips to improve control chart visualization

Hello,I created several control charts out of a JMP data table and saved everything as a report, I would like to do the following:how can I modify the script in order to get plotted only the last 30 datapoints from the data table?how can I modify the script in order to set the correct size of the chart? Right now every time I open it the graph is compressed on the left sideThanks for your support!
js1985

Discussions |
Dec 14, 2018 8:01 AM

7757 views | 11 replies
Creating webpage for html output

How do I create webpage where I can post jsl html output so that people without jmp can view html?
ENTHU

Discussions |
Dec 13, 2018 12:04 PM

7237 views | 4 replies
Combining scatter plot and broken line graph with the graph builder

Hi guys, I needs some idea for the graph builder.
I got problem after making a scatter plot which has several data on the Y axis. After that I recognized I have to build in a broken line graph which has the avg data.
I'm trying this by 2 methods but none works.

1. Adding a column that has the avg of the data to my data sheet and use the graph builder again -> Doesnt work because I dont know how to co...
sojun1218

Discussions |
Dec 13, 2018 6:55 AM

2707 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

2596 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

3253 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

3680 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

2511 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

3509 views | 0 replies