JMP User Community

Latest Discussions

How do I use a variable to reference a column in formula function?

Hi, I need to create a new column by apply formula on two existing column. I want to reference column through a variable rather than direct referencing. Here is the code , but formula seems doesn't recognize Column(ColVar). Anyone could help me to fix it? Thanks in advance. yCol = Column("weight"); xCol = Column("height"); Bivariate( Y( yCol ), X( xCol) ); colVar ="$weight"; dt = currentdatatable...
TraceTurtle5488

Discussions |
Feb 3, 2023 3:59 AM

1312 views | 2 replies
How to make Dashboard of Dashboards without keeping datatables open in memory?

I have a 500 item dataset, each one made up of about 500,000 data points. I want to make a report from each sub dataset and present the overall results of the 500 items with all of the resolution. The trival way is to make a dashboard/app of multiple datatables, but even if hidden they still take up memory and this is not an option. The end dashboard should give insights to notice issues within su...
John89

Discussions |
Feb 3, 2023 2:28 AM

895 views | 1 replies
Open a .jrp file with JSL, but the open function returns nothing

Hello, I met a problem that confused me so much.
When I open a .jrp file using Open() function, nothing is returned.

Names Default To Here( 1 ); rp = Open("<PATH-TO-FILE>\RxOsnrTol-01-Distribution-By(Temperature).jrp"); Show(rp);
Then in the log window, I got:

{Distribution[], Distribution[], Distribution[]} rp = .;
By the way, the .jrp file is opened and displays normally. It seems that the only probl...
Setsuna

Discussions |
Feb 3, 2023 12:38 AM

4743 views | 10 replies
Deleting and moving JMP data files on disk from JSL

There's an exceptionally helpful thread on this forum at https://communities.sas.com/message/32475#32475 which shows how to use DLL files to delete or move data files from within JSL, but the script appears to be specific to Windows. I'd like to assemble something that would work equally well on both Windows and Macs. Does anyone know if that can be done please - and if so, how?

Discussions |
Feb 3, 2023 12:20 AM

11055 views | 5 replies
Graph Builder Confidence Interval

I have made several plots using JMP's graph builder with a regression fitted line and the confidence interval gets wider and thinner (see attached below). Doesn't JMP use a confidence interval of 95%? Much appreciation for your helping this novice JMP user and budding statistics learner
fatemah

Discussions |
Feb 2, 2023 10:20 PM

10749 views | 5 replies

Previous
Next

Latest Discussions

How to make Dashboard of Dashboards without keeping datatables open in memory?

I have a 500 item dataset, each one made up of about 500,000 data points. I want to make a report from each sub dataset and present the overall results of the 500 items with all of the resolution. The trival way is to make a dashboard/app of multiple datatables, but even if hidden they still take up memory and this is not an option. The end dashboard should give insights to notice issues within su...
John89

Discussions |
Feb 3, 2023 2:28 AM

895 views | 1 replies
Design of Experiments based on covariates factors from two tables

Hi dear JMP enthusiasts and DoE lovers, I face a difficult situation and would like to know if there are any easier options. I would like to setup a DoE with 5 covariates : 2 covariates, from a table A, are predicted physico-chemical properties of formulations (thanks to the model of a first DoE),3 covariates, independent from the first ones, from a table B, are characteristics of different pack...
Victor_G

Discussions |
Feb 2, 2023 9:18 AM

1896 views | 4 replies
JMP 13 fails to open Excel files

Hello, I am JMP beginner and i have recently found a problem with my JMP 13 and specifically with the "open" option because i can't import Excel files and convert them into JMP tables.Whenever i try to import an Excel file it shows me this error "There was an error opening the file".However i can still manage to import my Excel files in JMP by dragging them to the JMP window, this gives me howeve...
CoxLeftLeopard3

Discussions |
Feb 1, 2023 7:39 PM

2088 views | 3 replies
how to sumerize the number column with of identical value per row in jmp

Hiwho know how to summarize the number column with of identical value per row in jmp? for example:MovieYearDomestic $######SUMOcean's Eleven2001$ 183.40$ 444.30$ 183.402Airport1970$ 100.50$ 100.50$ 100.503Armageddon1998$ 201.60$ 554.60$ 271.600Batman1989$ 251.20$ 413.00$ 413.002Batman & Robin1997$ 107.30$ 237.30$ 107.302Batman Forever1995$ 335.00$ 335.00$ 335.003 thanksCheli
Cheli

Discussions |
Feb 1, 2023 12:11 PM

1603 views | 4 replies
How do I use Regex substitution?

Replaces the specified "(" with a newline character and removes all non-Chinese and non-numeric characters. d试1(-是23(a文字789(+内c容4$3txt="d试1(-是23(a文字789(+内c容4$3"; na=Regex(txt, ？？ ); Thanks!
lala

Discussions |
Feb 1, 2023 5:11 AM

4780 views | 12 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

802 views | 0 replies
Choice experiment: probability profiler baseline assumptions

Dear community, For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data. Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...
Declan_JMP

Discussions |
Jan 23, 2023 3:54 AM

1617 views | 0 replies
Can we find some tutorials videos in YouTube?

Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!
Matheus_Plana

Discussions |
Jan 15, 2023 10:27 AM

1659 views | 0 replies
Data puzzles via Hanukkah of Data is underway

If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
XanGregg

Discussions |
Dec 19, 2022 11:21 AM

828 views | 0 replies
Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
Lavik17

Discussions |
Dec 19, 2022 10:20 AM

965 views | 0 replies