JMP User Community

Latest Discussions

rename column names in a jmp file as per values in rows in a separate .csv file

Hello, I am newbie to JSL, so appreciate help.
I have three files.file #1: It is the Reference file, [as ref.csv] holding 3 cols as below. Category, width, label
--------------------------------
A,0,L1.abc
A,1,L2.xt
A,2,L8.dr
A,3,L20.ws
A,4,L72.oz
B,0,L11.qq
....
B,6,L61.er file #2: data file#1 in JMP, holding Category, Data and many other cols.
file #3: data file #2 in JMP, holding Category, Data and many ...
david_sam

Discussions |
Jan 3, 2021 2:10 PM

4448 views | 10 replies
Loop? to count missing data from work with several columns and with column names which change names between the analysis (dates)

I have a question that I hope this community can help me with. I wish to add a column showing the consecutive days missing from the last day and backwards. I also wish to add a column counting the days where the result is higher than 0.02 from 7 columns.I have found a solution for both by using a series of if statements but wish to learn if it can be done in a more elegant way, maybe by using a lo...
Markku

Discussions |
Jan 3, 2021 1:24 AM

1893 views | 3 replies
ISSUE: Graph Builder > Preferences > Level Spacing Color = ON : Only applies to first plot created otherwise inactive

Hi JMP Community,Based on a relatively recent post (LINK), I tried to turn on all plot borders in GB by switching on the Level Spacing Color option to ON with a dark gray color.Surprisingly. this works only for the first plot I create in GB (3 X Levels by 2 Y Levels): each plot is framed as expected. However, if I close this first graph and recreate the plot a second (or third..) time, the plots a...
Thierry_S

Discussions |
Jan 2, 2021 5:47 PM

982 views | 1 replies
Possible to do Bayesian Regression in JMP?

I have a fairly straight-forward linear regression where the dependent variable is sales lift. The resulting confidence interval is fairly wide (and also currently crosses into negative lift which is impossible) and I'd like to tighten it up via a bayesian "credible estimate." I have what I consider to be a reasonably solid prior for sales lift. Can I do this in JMP? I admit I'm new to Bayesian re...
Scribe42

Discussions |
Jan 1, 2021 3:05 AM

1311 views | 1 replies
split a column and create multiple multiple based on split using JSL

Hello, I need to read existing table and find the column of interest [say the column name is "data"]. the column "data" is numeric with "dot" delimited and have same length. My goal is to open this table, read column "data" , remove the "dot" and create new columns [as per the length of value] and each column holds each value. Orig table:data------123.56.8.342431.02.0.567318.00.1.816..... expecte...
david_sam

Discussions |
Dec 31, 2020 9:20 PM

3533 views | 5 replies

Previous
Next

Latest Discussions

Loop? to count missing data from work with several columns and with column names which change names between the analysis (dates)

I have a question that I hope this community can help me with. I wish to add a column showing the consecutive days missing from the last day and backwards. I also wish to add a column counting the days where the result is higher than 0.02 from 7 columns.I have found a solution for both by using a series of if statements but wish to learn if it can be done in a more elegant way, maybe by using a lo...
Markku

Discussions |
Jan 3, 2021 1:24 AM

1893 views | 3 replies
ISSUE: Graph Builder > Preferences > Level Spacing Color = ON : Only applies to first plot created otherwise inactive

Hi JMP Community,Based on a relatively recent post (LINK), I tried to turn on all plot borders in GB by switching on the Level Spacing Color option to ON with a dark gray color.Surprisingly. this works only for the first plot I create in GB (3 X Levels by 2 Y Levels): each plot is framed as expected. However, if I close this first graph and recreate the plot a second (or third..) time, the plots a...
Thierry_S

Discussions |
Jan 2, 2021 5:47 PM

982 views | 1 replies
Possible to do Bayesian Regression in JMP?

I have a fairly straight-forward linear regression where the dependent variable is sales lift. The resulting confidence interval is fairly wide (and also currently crosses into negative lift which is impossible) and I'd like to tighten it up via a bayesian "credible estimate." I have what I consider to be a reasonably solid prior for sales lift. Can I do this in JMP? I admit I'm new to Bayesian re...
Scribe42

Discussions |
Jan 1, 2021 3:05 AM

1311 views | 1 replies
JSL to summarize delta ranges in different column

Hello, I have a data table that had 6 repeat test data set. I need to summarize index from each test but not sure how to do so: For each test, I need to summarize the time range (column 1) in between -0.5 to 0.5. For example for test 1, time between -0.5 to 0.5 is 12.Is this something doable in summary table or formula? What would be the right script for this? Any help is highly appreciated. Thank...
yuedeng1015

Discussions |
Dec 30, 2020 9:55 AM

1598 views | 2 replies
How do I ensure that my scalebox does not stay fixed in size

I kindly need help in to create a JSL script that does not make my variability chart scalebox stay fixed in one size because I'm having problems to see any values when the value is outside my control limits. Below is an image how the chart looks like for a given script. Appreciate it if someone could advise me how to let it ensure all the points inside this chart Variability Chart( Y( :chart_valu...
Danial1

Discussions |
Dec 29, 2020 7:59 AM

1880 views | 3 replies

Previous
Next

Latest Discussions

Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1523 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1326 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

831 views | 0 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1039 views | 0 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1271 views | 0 replies