JMP User Community

Latest Discussions

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
How to do Bilinear Interpolation using JMP?

Essentially it is called 2D multivariate interpolation. I have set of locations (x,y) and a corresponding data eg: z=color value. For some of the (x,y) the z column has data missing. I want to use the nearest two known ( x1,y1,z1) and (x2,y2,z2) to interpolate the value for (x3,y3, z3=?). Theoretically this wiki/Bilinear_interpolation is what I like to get. Does JMP has a way of doing this? Also ...
smostafa

Discussions |
Jan 17, 2019 8:16 AM

3654 views | 1 replies
define reference value of a nominal variable

HelloI'm using JMP Pro 12 and would like to know how to define the reference value of a nominal variable.For example, in order to use this variable in a Cox model.Without any defined reference for the nominal variable, JMP provides HR for each comparison between 2 groups, whereas i would like to compare each other group to the reference group only.ThanksFlorent
fguerville

Discussions |
Jan 17, 2019 4:32 AM

5308 views | 1 replies
How to delete a cell in jsl

I wanted to import a txt file into JMP, but the text is not perfectly aligned. So I want to delete the empty cells. I tried many different ways, but it seems that JMP can only delete an entire column/row. Is there a way to get from the Input to the Output format? Thank you. Input:NameColumn1Column2Column3Column4Column5Emma 38332083063031360Mary 38482634469445753Lisa3845961427554376643887David3832...
emmablue

Discussions |
Jan 16, 2019 7:59 AM

11323 views | 4 replies
Trend Evaluation where X = Ordinal and Y = Continuous?

Hi JMP Community,I would like to know if it is possible to evaluate(in JMP 13.1) trends in a data where X is ordinal (4 Groups) and Y is continuous (see attached file).Based on a visual inspection, it appears that the means of Measurements are progressively higher with each group but I have not been able to find a method to evaluate this formally. Thank you for your help. TS
Thierry_S

Discussions |
Jan 16, 2019 5:32 AM

4314 views | 1 replies

Previous
Next

Latest Discussions

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
How to do Bilinear Interpolation using JMP?

Essentially it is called 2D multivariate interpolation. I have set of locations (x,y) and a corresponding data eg: z=color value. For some of the (x,y) the z column has data missing. I want to use the nearest two known ( x1,y1,z1) and (x2,y2,z2) to interpolate the value for (x3,y3, z3=?). Theoretically this wiki/Bilinear_interpolation is what I like to get. Does JMP has a way of doing this? Also ...
smostafa

Discussions |
Jan 17, 2019 8:16 AM

3654 views | 1 replies
create an array

i want to create a num array, but how could i do it? example: if i have a data table,i want to use mean value of the first two columns and maximum of the last six columns to make an array, but i failed. a=mean(:column 1); b=mean(:column 2); c=max(:column 3); d=max(:column 4); e=max(:column 5); f=max(:column 6); g=max(:column 7); h=max(:column 8); array1=[a,b,c,d,e,f,g,h]; the jsl file i written ...
Yu

Discussions |
Jan 14, 2019 5:41 PM

5242 views | 2 replies
How to reference columns whose name begin with a number

I am looking to use the select where function within JSL script.However, it wont let me reference my column as it begins with a letter i.e 20GHz_timeI want to do :20GHz_time <1000 however it won't let me. I cant reference based on what column number it is as the columns can change from data table to data table so I need a way to capture it. What is happening is the :20 is getting highlighted in gr...
conroyco

Discussions |
Jan 14, 2019 4:07 AM

3589 views | 1 replies
Displaying output in a journal

I am using the following script to create a data report and finally save the result as html.The script plots a graph and a table to the right of the graph.Say graph1 and table1.I want to display table2 below table1. To create table2 I use tabulate function and then make into data table function. If I use the data box and append feature again, the table2 is displayed on the right of table1.But I ne...
ENTHU

Discussions |
Jan 10, 2019 6:47 PM

2872 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

2412 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