JMP User Community

Latest Discussions

select where conditions not met

I have a script running everyday to determine what parts have failed. We had a day where none of the parts failed and since my select where condition was not ("Fail") it grabbed all the passing parts and output them to the next table. How do I write it so that if no parts fail, the next tables should be blank? Example: Data Table ("Parts")<< select where (:PassOrFail == "Fail"); Data Table ("Pa...
LasersAreCool

Discussions |
Jan 4, 2022 11:22 AM

968 views | 2 replies
How do I get unlinked X-axes (separate min and max values) in GraphBuilder?

HiI would like to have separate values (min and max) on the x-axis for F and M (BigClass example), so for example F goes from 60-140 while M goes from 70-160. Is this possible? or could there be some other way around it?
NRE_DK

Discussions |
Jan 4, 2022 9:18 AM

1726 views | 4 replies
Cochran Armitage exact?

I have data for a 5 year period. there is binary feature (registered/unregistered) represented by a column in the data. I want to see if there is a trend for proportion unregistered items year by year across the 5 year period. The Cochran Armitage trend test seems like the appropriate statistic (yes?). The the number of unregistered items is single digits for multiple years, and is even zero ...
dweinber

Discussions |
Jan 4, 2022 6:54 AM

1185 views | 1 replies
JMP > JSL > How to Pass Arguments to Add-In included my own script?

Hi JMP Community, I am an avid user of John Sall's FDR calculation Add-In (com.sas.sall.fdrpvalue.jmpaddin) in analyzing large biomarker data. While the manual input of data in this Add-In is straightforward, I have not figured out how to pass arguments from my JSL scripts into this tool. I know that I have to use the Include ("[Add-in]") command to enable the use of the Add-In in my scripts, ...
Thierry_S

Discussions |
Jan 3, 2022 4:16 PM

1572 views | 2 replies
Need help with For Loop

I am new to JSL but with the help of this community I was able to write a piece of code to collect air quality data from a URL for a specified pollutant and period of time. Everything works fine in the code except for when there is no data in the URL and then the For Loop breaks. Is there any way to put a condition so the For Loop ignores the table with no data? I am pasting the code below. If you...
shasheminassab1

Discussions |
Jan 3, 2022 12:59 PM

1818 views | 2 replies

Previous
Next

Latest Discussions

select where conditions not met

I have a script running everyday to determine what parts have failed. We had a day where none of the parts failed and since my select where condition was not ("Fail") it grabbed all the passing parts and output them to the next table. How do I write it so that if no parts fail, the next tables should be blank? Example: Data Table ("Parts")<< select where (:PassOrFail == "Fail"); Data Table ("Pa...
LasersAreCool

Discussions |
Jan 4, 2022 11:22 AM

968 views | 2 replies
Cochran Armitage exact?

I have data for a 5 year period. there is binary feature (registered/unregistered) represented by a column in the data. I want to see if there is a trend for proportion unregistered items year by year across the 5 year period. The Cochran Armitage trend test seems like the appropriate statistic (yes?). The the number of unregistered items is single digits for multiple years, and is even zero ...
dweinber

Discussions |
Jan 4, 2022 6:54 AM

1185 views | 1 replies
Making a heat map- how to customize the interval of the legend?

Hello,I am making a heat map, so the legend of my graph is a color gradient with corresponding numbers. JMP seems to choose the values automatically based on the data set that correspond to the gradient. I am going to attach an image so that it is more clear, but basically JMP has decided that the values on my legend are (-20, -14, -8, -2, 1, 2, 3, 4, 5), and obviously these numbers are not a regu...
ClusteredMining

Discussions |
Jan 3, 2022 11:23 AM

3333 views | 4 replies
95% confidence interval calculation from profile for Excel

Dear all,One of my friend doesnt have jmp. I prepared an excel for it. But I just calculate prediction value from equation. I do not calculate 95% upper lower prediction of model in excel. Could you please inform how can i calculate 95%range of prediction model in excel. I used nonlinear part of jmp.Thanks anyone help to solve this issue.
nac

Discussions |
Jan 3, 2022 7:00 AM

2146 views | 1 replies
separating labelled values from graph points

I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...
Cdougz

Discussions |
Dec 31, 2021 7:38 AM

913 views | 0 replies

Previous
Next

Latest Discussions

separating labelled values from graph points

I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...
Cdougz

Discussions |
Dec 31, 2021 7:38 AM

913 views | 0 replies
Expand Contours

Hi,

I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks!
MikeDereviankin

Discussions |
Dec 15, 2021 12:49 PM

711 views | 0 replies
Getting all Zeros for the AR(1) estimate/std error in a Repeated Measures Mixed Model Using JMP Pro

I am fitting a model of a continuous response against 7 fixed effects. When running the Standard Least Squares; my residuals plots/assumptions checks don't look too bad but the Durbin Watson test is suggesting an AR(1) structure in the residuals. This is expected for this particular analysis and is consistent with other data sets looking at the same response/factors. The Time Series platform also ...
lisa2442

Discussions |
Dec 14, 2021 7:32 AM

873 views | 0 replies
Export Functional Data Explorer prediction formula

Hi,I want to export the prediction formula generated by Functional Data Explorer either to Excel or Python (via Formula Depot), but there is a problem because the formula contains P Spline Coef() interpolation, which I think is not available in Excel or in Python libraries. Do you have any suggestions how to solve this?Best regards
ruskicar

Discussions |
Dec 14, 2021 2:11 AM

831 views | 0 replies
Need help with changing separators lines location in a variability graph

Hello,I need to change the locations of the separators line in the graph.In the attached image, I need the separators lined on the upper row (labeled ISI).I have tried to find how to do that without success.Thanks
SHRG

Discussions |
Dec 10, 2021 8:59 AM

1089 views | 0 replies