JMP User Community

Latest Discussions

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

11339 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

4350 views | 1 replies
Formula Loop - variable columns

Hi, I have a problem with the script.
I get an empty column when I try to use the loop.When I don't use a loop, it's works.col = dt << get column names; For(i = 1, i <= N Items(col), i++, c = "c" || Char(i); Eval(Parse(Eval Insert("^c^= column(dt,i)<<get values")))); New Column( "Flag", Character, Nominal, Formula(for(i=1,i<3,i++, if(c2[i]>:LSL[i],"Pass","Failed"))));
Botzal

Discussions |
Jan 15, 2019 11:38 PM

5143 views | 4 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

5245 views | 2 replies
How to get column number from column name? (JMP)

This may be a really simple question but after a lot of searching and testing I can't figure it out. How do I get the column number for a given column if all i know is the column name from a column dialog box?Minimized code:dlg = Column Dialog( dlg_firstParam = ColList( "First Parameter"));firstParam = dlg["dlg_firstParam"][1];i = 5; // this is a test case. Assume i am going to select the fifth ...
mikedriscoll

Discussions |
Jan 14, 2019 9:14 AM

16273 views | 3 replies

Previous
Next

Latest Discussions

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

5245 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

2876 views | 1 replies
Can I have a different local data filter for each column using the column switcher?

I am looking to use the column switcher, but each column needs a different local data filter. Is there a way to assign a specific local data filter to each column? I have attached a JMP file with the three separate graphs I want with their appropriate data filters, and would like to have one graph using the column swicher to cycle through each. (Column switcher for Temp, pH, and concentration.)
kk

Discussions |
Jan 10, 2019 12:18 PM

5220 views | 7 replies
Memory usage when creating many tables

When creating many tables and then closing them JMP seems to keep the tables or some remnants in memory. The memory is sometimes released after a while. I ran into this when simulating a measurement situation with noise sources. JMP din't crash but after RAM ran out windows started swapping to HDD. Below is the simplest example where I was able to repeat the problem. Question: is this expected beh...
Niko_Porjo

Discussions |
Jan 10, 2019 2:08 AM

6482 views | 4 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

3112 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

3437 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

2328 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

3281 views | 0 replies