JMP User Community

Latest Discussions

Color cells by specific condition

Hi, I'm new for JSL.I want the cell to change color based on specific condition.for example, I want :dIGSS>5 get red color. dt << Get Rows Where(:dIGSS>5); :dIGSS << Color Cells(3);But all dIGSS rows change to red. I've found an example which can change cell's color based on specific condition, but it is for each column:For Each({colname}, dt << Get Column Names("String"), rows_to_color = dt <<...
LT

Discussions |
Jan 1, 2024 5:28 PM

2039 views | 3 replies
SAS to JMP data connectivity

I'm currently working with a SAS 9.4 file and looking to transfer it to JMP Pro 17.2. I've encountered an issue where the button in SAS, which is supposed to export data to JMP, is not functioning properly. Could anyone provide guidance on how to successfully transfer my data from SAS 9.4 to JMP Pro 17.2? And I have SAS 9.4 and JMP Pro 17.2 installed, but I'm unsure of the steps needed to integra...
thiennguyen

Discussions |
Dec 31, 2023 9:08 AM

980 views | 1 replies
How to deal with missing data?

Hi,

Recently l ran a 2^4 factorial model for an extrusion experiment. I intend to model the quadratic terms including interaction terms.

however some of the points were a little ambitious and the extrusion failed. Hence, I was unable to collect certain responses for these points. I would like some advice on how to proceed. Should I repeat the experiment with less aggressive levels or can I just augm...
sianghongtay22

Discussions |
Dec 31, 2023 12:13 AM

1455 views | 4 replies
Enter "NewLine"

I want to split a string in a character column into two lines - by adding a newline.dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); name[1] = "A\!nB" Can I do this directly when editing the cell - Alt + Enter doesn't seem to be right?
hogi

Discussions |
Dec 30, 2023 5:05 AM

2358 views | 6 replies
Copy pasting means and std deviation table from a Oneway analysis.

Hello all! First time posting here so I apologize if I miss anything. I wrote script which essentially creates a oneway analysis for user imported data. I was wondering if it was possible to extract (copy paste) the "Means and Std Deviations" table to a different table in JSL. Ex:
OhThatArabGuy

Discussions |
Dec 29, 2023 1:31 PM

903 views | 1 replies

Previous
Next

Latest Discussions

How to deal with missing data?

Hi,

Recently l ran a 2^4 factorial model for an extrusion experiment. I intend to model the quadratic terms including interaction terms.

however some of the points were a little ambitious and the extrusion failed. Hence, I was unable to collect certain responses for these points. I would like some advice on how to proceed. Should I repeat the experiment with less aggressive levels or can I just augm...
sianghongtay22

Discussions |
Dec 31, 2023 12:13 AM

1455 views | 4 replies
What Analysis is appropriate to get the mortality data

I'm checking the mortality data for only one concentration of the chemical. Can u please help me in the statistical analysis. Im not really having an idea as to how to go about which analysis and how to do it.
Ashwa

Discussions |
Dec 28, 2023 6:35 PM

707 views | 1 replies
Generate a report of database schema and sample data from each table

Is there a way I can generate a report that shows me all the tables in my database along with all of the columns of each table and the first 1-2 rows of each table (I may recognize the actual data better than the name of them column)? BonusBecause some tables have many columns and it is easier to scroll down and print down than sideways, is there a way to make this report such that the first 1-2 r...
Momentum

Discussions |
Dec 28, 2023 5:36 AM

2909 views | 7 replies
Question: Table summary but lost column property of spec limits?

Hi,I have a question about table summary but lost column property of spec limits, could you help?Attach file is data.jmp I use summary function in JMP and did click [link to original data table].But the spec limit data lost in summary result table.Any way to link to original table spec limits? Thank you. Regards,Chily
Chily

Discussions |
Dec 28, 2023 12:21 AM

942 views | 2 replies
Adding Progress bar in the script

Hello , I have a data table with a million rows and am trying to add a progress bar window in the script. I found this threat (Progress bar) from Craige useful. I am new to this, so I am still trying to understand where to add the code to indicate the progress. Any suggestions?

Code for a Progress bar from @Craige_Hales progressBarWidth = 500; progressUpdatesSeconds = 1 / 4; // 1/2 sec updates -...
Jackie_

Discussions |
Dec 27, 2023 8:00 AM

1156 views | 2 replies

Previous
Next

Latest Discussions

Documentation for Promise/async http requests

Hi, I was wondering if anyone knows of any documentation for Promise objects. So far I am finding fairly little in the scripting index or at https://www.jmp.com/support/help/en/17.2/index.shtml. I am currently working from the Send documentation, which gives an example and demonstrates that you can use `<< On Response` and `<< On Error`, but not what else, if anything you can do with a Promise obj...
mat-ski

Discussions |
Dec 22, 2023 9:45 AM

543 views | 0 replies
Nonlinear platform - trial values from table with large number of categories

Hello - I have a large number of categories for each parameter when using the nonlinear platform. Basically, one category per row. Is there a way to have a table of values to load into the parameters? Because with the time its taking to one by one type and click, type and click the values in with the control panel, it might be faster to go back to Matlab at this point, which I very much don't want...
ehchandlerjr

Discussions |
Dec 18, 2023 2:50 PM

462 views | 0 replies
Sphericity test not performed due to insufficient error degrees of freedom

Hi,I have Heart rates from 3 different groups collected at 7 times differents points. I would like to perform a repeated measures ANOVA. To do so, I would like to check sphericity assumption. I found online that you have to split your data and then Analyze > fit model, I add my 7 times in "Y" then Group in "Construct model effects", then Personality "Manova", Run. I checked “Univariate Tests Also”...
ClassMegalodon6

Discussions |
Dec 14, 2023 2:54 AM

755 views | 0 replies
Survival analysis

What is the rationale of using three different types of log-rank equivalent tests (Mantel-Cox, Breslow, and Tarone-Ware). How can I examine the confounding effects of other factors when running the survival analysis?
fgaochori

Discussions |
Dec 13, 2023 11:31 AM

591 views | 0 replies
Select ALL matching cells

very useful!
it selects the matching cells in all open datasets (e.g. select a specific wafer and get it highlighted in the other datasets)
Working with Rows ... but a little hard to find

note to mysef: not here - or here: but here: Thankyou, @Jasean for showing me the way ...
hogi

Discussions |
Dec 9, 2023 3:12 AM

664 views | 0 replies