JMP User Community

Latest Discussions

Split function: what is happening when one column is not added into "Group"

I got a problem with SPLIT when 1 column was not included in Group. I intended to make it not in Group and hope it the values in another column can be averaged.So I made a sample Data Table to play and try to understand what's going on.Sample table below:Scenario1:I want to Split "Random metric value", Split by Tool A&B, Group by only "Test", and hope the "random metric value" from different itera...
Zihao

Discussions |
Aug 19, 2022 2:14 PM

1062 views | 1 replies
Finding Min Value in a set of data and populating it in next column then selecting it to subset it

Hi,From the attached test2.JMP file I am looking to eventually get Subset of Result.JMP.so basically I am looking to:1) find the min value until there is no data for -3dB column then populate that min value in the next column but same row2) Select the rows with only those min value populated in another column3) Subset the selected rows.I tried min, col min, rank etc functions but with no luck. Fin...
LearningJMP

Discussions |
Aug 19, 2022 9:59 AM

1985 views | 4 replies
Graph Builder not showing all data when building with multiple data sets.

I've been working with a data set of g/L EtOH vs Time with multiple, Batch, data sets and started to notice that the graph builder isn't showing some of my runs. Has anyone ever experienced this while using graph builder? I've tried remaking the column and hand typing my data for my Y values without any success in fixing the issue. I have attached a photo that shows what I'm experiencing via grap...
dfgonzalez

Discussions |
Aug 19, 2022 9:55 AM

2069 views | 2 replies
File used in STIPS course not available in Sample Data

Specifically I am looking for CCD Temperature and Time.jmp. Anyone of the SAS staff willing to share a copy of this file?
Ressel

Discussions |
Aug 19, 2022 9:43 AM

1326 views | 2 replies
Select rows in one table with values identical in another table

I have two tables: tableA and tableB.Rows in one column (say col-1) in tableB has values also occurring in tableA in a column (say col-15). Length or col-15 >> col-1.Can I interactively select the rows in col-15 (of tableA) with entries also occurring in col-1 (of table-B)?If interactive selection is not possible, how to script such a selection process?Thanks.
Neo

Discussions |
Aug 19, 2022 7:16 AM

1723 views | 3 replies

Previous
Next

Latest Discussions

How do I determine whether the data in the specified range meets the criteria?

For example, find the height column with four consecutive rows between the top 10 rows and the top 20 rows >>60 and <65.Thanks!
lala

Discussions |
Aug 19, 2022 7:06 AM

803 views | 1 replies
Writing Excel formula in JSL script (Formula in attached excel file)

Hi,I am trying to replicate formulas that are currently in the attached excel sheet.Where, DSA_Step_Size(dB) = ABS(of delta of :RESULT rows when ATT1 values are decreasing for the same :FREQUENCY value).The formula is in excel sheet if my explanation is confusing. DSA Range(dB) = ABS(of delta of :RESULT rows when ATT1=63 and ATT1=0 for each :FREQUENCY). I am trying to use for loops in the formula....
LearningJMP

Discussions |
Aug 18, 2022 6:17 PM

1817 views | 2 replies
How to create an application with a data filter in the launch module?

I'm trying to create an application to produce reports based on user input. I have some experience with writing scripting, but am getting stuck and I haven't used Applications before.I have tried to modify one of the example Applications that come with JMP, but none of these have a data filter in the launch module and what I have tried to do isn't working.Does anyone have an example of a simple ap...
ckronig

Discussions |
Aug 16, 2022 11:41 AM

4060 views | 10 replies
JSL select rows near the maximum value of a column

Hi,I have a data series shown in the screenshot below, and try to select only the data in the range of "x +/- 0.3" with the center at the maximum value of "y".I got an error message "The argument to SelectWhere did not evaluate to true or false, it is [0]..." from the highlighted line, as shown below. What is puzzling is that the last line worked when only 1 condition is applied.What is wrong with...
CurseOfLizard13

Discussions |
Aug 16, 2022 10:45 AM

1986 views | 4 replies
How do you import JSONs that contain double nested arrays?

I'm trying to import a number of JSON files that contain double nested arrays (see example below). The arrays don't follow a consistent format, there could be numerous objects in each array or none at all. I want to have one score per row as shown below.How can I get the data in this format using the import tool? Also, the name of the prediction is not always spelt the same e.g. sometimes it's "Sm...
BagOfMiningLion

Discussions |
Aug 16, 2022 9:41 AM

4409 views | 6 replies

Previous
Next

Latest Discussions

JMP Pro, Dantzig selector: how do I improve computational time

Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Not_A_Student

Discussions |
Aug 12, 2022 7:49 AM

746 views | 0 replies
JSL Script Creates New Taskbar Icon When Run

Hi All, I have what seems to be an odd problem. I've created a JSL script that launches a window through which a user can select some options and then run scripts to pull data from various sources. The odd thing that is happening is that when one of these scripts is run it causes all subsequent JMP windows to open under a new taskbar icon. An example for clarity: 1) User opens jmp. There is 1 icon...
jbakri

Discussions |
Aug 1, 2022 12:32 PM

1122 views | 0 replies
Choice model platform and marginal effects?

Hi everyone,I have used the choice model platform to design and analyse choice experiments. However, at the analysis step, there are some parts of JMP platform output that are not clear, and I wonder if you can provide an answer:It is not clear how marginal effects are calculated in JMP.More specifically, how do we obtain marginal probabilities from marginal utilities since neither the utility fun...
gav2013

Discussions |
Jul 18, 2022 7:14 AM

1034 views | 0 replies
July/August classes from JMP Education

JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for Non-Repairable Systems August 9-12: JMP Pro: Analyzing Curves and Profiles Using the Functional Data Explorer August 16-19: JMP: Statistical Decisions Using ANOVA and Regression August 29-September 1: J...
Di_Michelson

Discussions |
Jul 11, 2022 8:50 AM

681 views | 0 replies
Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

798 views | 0 replies