JMP User Community

Latest Discussions

how to script for finding maximum, minimum date value in a row for 100+ columns

i have a table with 500+ rows and 100+ columns. Populated with numeric values (dates). I need to find the maximum and minimum value along each row for earliest and latest date. i guess the script would be similar to 'Maximum (column1........column100)' for each row. But i am not sure how to script the column ranges along each row.
tonkatsu2020

Discussions |
Oct 16, 2020 1:29 PM

4544 views | 10 replies
test for colinearity

I have a nominal outcome variable (ICU admission yes/no)Predictor variables are both categorical (like presence of some symptoms yes/no) as well as continuous (like age body mass index)There is however a potential for co-linearity between these predictor variables.The nominal logistic regression model does not give me a option to calculate VIF upon right clicking the parameter estimates.What would...
Sandeep123

Discussions |
Oct 16, 2020 1:18 PM

2767 views | 5 replies
How to build up a Face centered central composite design with JMP

Hey JMP users, I need to build up a Face centered CDD with 3 factors, each at 3 levels, 2 blocks and 4 center points. This is how I proceeded: 1) select Classical > Response Surface Design 2) add 3 factors > Continue3) Here I don't know if I should select "Central Composite Design" or "CDD-orthogonal Blocks" as I need to add one blocking factors with 2 levels however the CDD does not allow me to a...
JMPdiscoverer

Discussions |
Oct 16, 2020 9:07 AM

4844 views | 7 replies
Possible to add automatic graph creation in JSL script?

Hello, I wrote a JSL to organize experimental data which updates 22 data tables (corresponding to products), each containing columns for different physicochemical parameters (e.g. pH, osmolality). Currently, I am manually creating graphs using the Graph Builder feature and 'saving script to data table', however I was wondering if it was possible to write this into the main JSL script that is gener...
DanAlexander

Discussions |
Oct 16, 2020 6:58 AM

22595 views | 15 replies
With JSL what is the correct syntax to set the Column property "Reverse"

Hi,I need to set the properties of a Column to 1) Row Order levels and 2) Reverse.
So far I can do the first one without any problems. dt:ColXYZ <<Set Property ( "Row Order Levels", 1 );However I cannot find anywhere what is the correct syntax to emulate the GUI button "Reverse" I have tried several ways but none have worked.
ALopez

Discussions |
Oct 15, 2020 4:08 PM

2394 views | 2 replies

Previous
Next

Latest Discussions

how to script for finding maximum, minimum date value in a row for 100+ columns

i have a table with 500+ rows and 100+ columns. Populated with numeric values (dates). I need to find the maximum and minimum value along each row for earliest and latest date. i guess the script would be similar to 'Maximum (column1........column100)' for each row. But i am not sure how to script the column ranges along each row.
tonkatsu2020

Discussions |
Oct 16, 2020 1:29 PM

4544 views | 10 replies
test for colinearity

I have a nominal outcome variable (ICU admission yes/no)Predictor variables are both categorical (like presence of some symptoms yes/no) as well as continuous (like age body mass index)There is however a potential for co-linearity between these predictor variables.The nominal logistic regression model does not give me a option to calculate VIF upon right clicking the parameter estimates.What would...
Sandeep123

Discussions |
Oct 16, 2020 1:18 PM

2767 views | 5 replies
How can I get an epsilon with a dot above in JMP?

Hi, I would like to use an epsilon with a dot above in JMP, so I can directly use plots from JMP in publications and reports. A "dot above" is often used to indicate a derivative wrt. time.I tried to use the Character Map from Windows to combine the "epsilon" and "dot above" and copy that to JMP but always end up with a dot at the position of the superscript instead of above: ε˙. What I would need...
matthias_bruchh

Discussions |
Oct 15, 2020 3:58 PM

3944 views | 8 replies
Removing Fit Lines

Hello, I created a Normal Quantile Plot by... Analyze --> Fit Y by XNormal Quantile Plot --> Plot Quantile by Actual There are a lot of fit lines on the plot that I'd like to remove, but I can't find how to do it. I've checked preferences as well, but it is not obvious to me.
natalie_

Discussions |
Oct 14, 2020 8:00 PM

2796 views | 3 replies
Sort order in custom sort window

How does the JMP Sort window pass ascending and descending from the buttons to the Col List Box (ListBoxBox?) to the OK button? I need to make a custom sort window with limited options for data tables in a report. I figured out how to do most of it, either building up a sort window from scratch, or starting with the JMP sort window. An example with the latter follows. How do I get order_list == ?...
twalk

Discussions |
Oct 14, 2020 6:03 PM

1019 views | 1 replies

Previous
Next

Latest Discussions

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

1018 views | 0 replies
order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

720 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

803 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

976 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1271 views | 0 replies