JMP User Community

Latest Discussions

Create New Column if the list contains

Hi,I have a list which contains column names. I want to create a new column if the column name exist in the string list. Here's my code. It works but creates duplicate column names bc of the loop. Any advice? Names Default To Here( 1 ); Clear Globals(); Clear Log(); dt = Current Data Table(); col_list = dt << Get Column Names( string ); idds = {52,54}; For( i = 1, i <= N items( idds ), i++, I...
Jackie_

Discussions |
Aug 2, 2022 6:46 PM

983 views | 1 replies
Bulk change to log scale and color of reference line

Hi, I used "fit y by x" in JMP16 to generate about 25 graphs. How can I change all of their scales to log scale without going to individual graph's axis settings please? Also, each one of the graphs have their unique USL that gets displayed a reference line in color blue. How could I change all the 25 reference line's color from blue to red please? Thanks!
monu_maverick

Discussions |
Aug 2, 2022 11:02 AM

3099 views | 5 replies
Import x and y values from the text file to jmp table

Hi, Reading each line in text file and import each string as a separate row in the jmp data table
Jackie_

Discussions |
Aug 2, 2022 9:50 AM

12122 views | 27 replies
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

1744 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

1130 views | 2 replies

Previous
Next

Latest Discussions

Bulk change to log scale and color of reference line

Hi, I used "fit y by x" in JMP16 to generate about 25 graphs. How can I change all of their scales to log scale without going to individual graph's axis settings please? Also, each one of the graphs have their unique USL that gets displayed a reference line in color blue. How could I change all the 25 reference line's color from blue to red please? Thanks!
monu_maverick

Discussions |
Aug 2, 2022 11:02 AM

3099 views | 5 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

1019 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

1318 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

2252 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

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

1097 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

1011 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

663 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

784 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

631 views | 0 replies