JMP User Community

Latest Discussions

Parse a Data Table Name or File Name; Extract; Split; Word

Hello, Haven't yet figured out how to parse fields in a file name or use word() function with the text argument a variable rather than a true text string. Example: dtd00 = Open( "$0802\field1_field2_field3.txt", Import Settings( End Of Field( Spaces, Space, CSV( 0 ) ) ) ); // my_fld1 = Word( 1, "field1_field2_field3.txt", "_" ); // // This does set my_fld1 = field1 my_fld2 = Word( 2,...
johnm

Discussions |
Aug 2, 2022 9:24 AM

1309 views | 2 replies
How do I input different values for each JMP file using a script?

open=("C:\source\new.jmp); For ( i=1, i<= nitems(files), i++, data table("new")<<new column("month",charcter,formula(eval("Jan"))); );I know that the above script is wrong, and I wrote it as a rough example.There are 3 JMP files of the same type in the source folder.After creating a new column using the For SCRIPT
I want to put January, February, and March in the file order.I need help figuring ou...
Ronaldo

Discussions |
Aug 2, 2022 3:48 AM

820 views | 2 replies
Table variable slider affecting column formula incorrectly

Hi everyone, I am putting together a demo table that is supposed to domenstrate how a statistical test changes as the mean and difference in means between two groups shifts. In this table, I have 4 table variables, two which represent the mean of a reference group (POR) and two that represent as shift from that mean. There are two formula columns thatare dependent on these variables, but each colu...
ElBurro777

Discussions |
Aug 2, 2022 12:53 AM

772 views | 1 replies
Graph Builder: Additional Y variables with the same color

Hi JMP Community, currently, I am writing a script that creates a plot template among other stuff in form of a pre-filled graph builder. Script below. The open graph builder is supposed to be used by the user who usually wants to have a look at other signals in addition to the existing 4 in the plot. So he usually starts to drags another column and drop it on top or at the bottom of the existing 4...
Robbb

Discussions |
Aug 2, 2022 12:43 AM

961 views | 3 replies
Find and Replace all instances of a specific character with another character but leave the rest untouched

Heyho! I am currently trying to replace all instances of "." with "," in a script, since I am in the EU and that is our decimal. Have seen some solutions to about the same problem that I have but they do not seem to work or I am just too stupid to use them for my case. Any help is appreciated! I will attach a picture of my data. Kind regards, Lien
Lien

Discussions |
Aug 2, 2022 12:34 AM

2493 views | 5 replies

Previous
Next

Latest Discussions

Table variable slider affecting column formula incorrectly

Hi everyone, I am putting together a demo table that is supposed to domenstrate how a statistical test changes as the mean and difference in means between two groups shifts. In this table, I have 4 table variables, two which represent the mean of a reference group (POR) and two that represent as shift from that mean. There are two formula columns thatare dependent on these variables, but each colu...
ElBurro777

Discussions |
Aug 2, 2022 12:53 AM

772 views | 1 replies
Graph Builder: Additional Y variables with the same color

Hi JMP Community, currently, I am writing a script that creates a plot template among other stuff in form of a pre-filled graph builder. Script below. The open graph builder is supposed to be used by the user who usually wants to have a look at other signals in addition to the existing 4 in the plot. So he usually starts to drags another column and drop it on top or at the bottom of the existing 4...
Robbb

Discussions |
Aug 2, 2022 12:43 AM

961 views | 3 replies
How to show reference line labels in Normal Quantile Plot (JMP 16)?

This question is about the Normal Quantile Plot in JMP 16.Is it possible to show reference line labels on the primary Y-axis (Label Position: Outside, Label Axis Side: Same)?Here is what I have done:Sample data file: Big Class.jmpAnalyze > Fit Y by XY, Response: weightX, factor: sexIn the resulting Normal Quantile Plot I removed Y-axis Grid Lines and Labels, and attempted to replace them with my o...
Rondin1989

Discussions |
Aug 2, 2022 12:27 AM

1697 views | 3 replies
Finding value of column y at max value of column X

I want to find the maxium value in column "Power (dBm)" grouped by BarID, ChipID.And use that to find the corresponding value in column "Wavelength (nm)" to give me a summary table showing the value of maxium power and what value of wavelngth it occurs at grouped by BarID, ChipID etc.
sipho-ss

Discussions |
Aug 1, 2022 5:41 PM

928 views | 1 replies
Col Cumulative Sum by group increases counter if first row is missing or empty

I found this behavior while using the Col Cumulative Sum() as a way to create a counter. If the group column has a missing value in the first row, the groups are completely ignored, see the last column below.
FN

Discussions |
Aug 1, 2022 1:41 PM

879 views | 3 replies

Previous
Next

Latest Discussions

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

821 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

810 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

482 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

618 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

484 views | 0 replies