JMP User Community

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

4816 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

15544 views | 3 replies
Concatenate Multiple tables with different column order

Team,I have 5 csv files each having 200column (not each file have same number of columns). Each file has columns in different order. I want to write a scirpt which will let user to select all 5 files then combine all 5 files (dropping mismatched columns) and save the combined csv file to the required location. I want to use command similar to (data = Open(Pick File("Choose the File", x)), x is the...
Rajat

Discussions |
Jan 14, 2019 8:11 AM

6437 views | 11 replies
Convert List to Matrix

What is the quickest way to convert a list: {"a", 1, 2, "b"} into a matrix: [. 1 2 .]? I expect that I can just loop through all of the elements, but I'm hoping there is a quicker way since I will be doing this many thousands of times in my application, with each list containing hundreds of elements.
MarkDayton

Discussions |
Jan 14, 2019 6:55 AM

14778 views | 9 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

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

4816 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

3305 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

2651 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

4562 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

5986 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

2227 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

2921 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

3232 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

2067 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

2941 views | 0 replies