JMP User Community

Latest Discussions

Extract numbers of varying lengths from a string into different columns

I have a column named Duration with values which represent number of days,hours, min and sec. The last m denotes seconds.So the typical format would be : (0-365)d(0-24)h(0-60)m(0-60)mHere are some examples.:0d 15h 47m 43m10d 10h 21m 54m0d 04h 07m 32m268d 06h 02m 33m I need to extract the number of days, Hours,minutes, and sec in different columns so that I can perform calculations on it.I tried t...
SunnyR

Discussions |
Aug 7, 2020 9:34 AM

8165 views | 12 replies
How to do 2-stage least squares (2SLS) / Instrumental Variable regression / Heckman self-selection model

Hi there, Is it possible to do a two-stage least squares model or IV regression or Heckman self-selection model in JMP? Is it also possible to get the inverse Mills ratio? Thanks in advance!
Heckman123

Discussions |
Aug 7, 2020 6:59 AM

2381 views | 1 replies
Lookup tables using JSL

Hi, I wrote some code to implement a rudimentary lookup table for a voltage/time dataset. But because of the size of my dataset, it is freezing up. Quick background, there might be around 1000 rows (time intervals) for each run and there are around 1500 runs, so 1.5m rows in total. In a nutshell, I am doing the following in my code before I start using the lookup table:- Process dataset- Calculate...
mtrain

Discussions |
Aug 6, 2020 6:32 PM

4050 views | 5 replies
What is the role of "Freq" in the Partition decision tree model?

Please consult the experts: Are there any examples of how "Freq" plays a role in the decision tree model of "Partition"? I searched for the script and couldn't find it. Thanks!
lwx228

Discussions |
Aug 6, 2020 4:17 PM

5829 views | 11 replies
Graph builder 200-point data limitation with nested x axis character variables

Ran into an issue today trying to create a plot with graph builder (JMP 14). Y axis is from a column of continuous numeric data (200 total rows of data). X axis has nominal character data "Run Index" that is ordered (ascending) by data in the date column (continuous numeric date data) by dropping that column above Run Index on the X axis. When I add another nesting character variable "Run catego...
jc510

Discussions |
Aug 6, 2020 9:42 AM

4572 views | 5 replies

Previous
Next

Latest Discussions

How to do 2-stage least squares (2SLS) / Instrumental Variable regression / Heckman self-selection model

Hi there, Is it possible to do a two-stage least squares model or IV regression or Heckman self-selection model in JMP? Is it also possible to get the inverse Mills ratio? Thanks in advance!
Heckman123

Discussions |
Aug 7, 2020 6:59 AM

2381 views | 1 replies
DOE Question: Contraints on Categorical Factors

I would appreciate some advice... I am running a screening experiment with strictly categorical factors and trying to identify the primary source of variation in my response. The experiment involves material going into a surface process (known significant effect), followed by a bake (which needs to be done in batches to process everything through - any oven run to oven run variation?), followed ...
amjg

Discussions |
Aug 6, 2020 8:38 AM

1829 views | 2 replies
Web map services-2020

I noticed in JMP 15, there is an option to provide links to Web map servers under the background map option (formerly, you needed to use an add-in: WMS Explorer Add-In ). I like this option because there are some super high resolution maps out there. But it seems like the two biggest WMS, Google Earth and ArcGIS, cannot interface with JMP. What I am trying to figure out is whether I am setting it ...
abmayfield

Discussions |
Aug 6, 2020 8:03 AM

2586 views | 3 replies
Why does "Link to original data table" selection remove values in formulated columns in the created subset?

I have a question about subsetting a data table. When I created a subset which included some columns with formulas "+", I initially checked off the selection "Link to original data table" for the new subset I was creating. After this was done, any column from the original data table subsetted into the new data table that had a formula associated with it showed no data at all. However, I went bac...
ChristinaF

Discussions |
Aug 5, 2020 11:40 AM

1596 views | 1 replies
Dynamic chart creator

Hi,I would like to write a script that helps the user to create some required charts with less mouse clicks.For example, typically when I'm making charts manually, I have to first create X-Y graph, then select legend, then click on Automatic recalc, Unselected faded, group by, and put splines. This turns out to be very tedious.So basically what I want to write is a script that the user would only ...
Yotam

Discussions |
Aug 5, 2020 5:56 AM

3447 views | 6 replies

Previous
Next

Latest Discussions

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

1317 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

1561 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1313 views | 0 replies
[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1194 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1174 views | 0 replies