JMP User Community

Latest Discussions

Concatenate data table from subset

Hi all, I have to subset a data table and concatenate the data tables one by one into another file. How can I concatenate the data tables from the subset table to the original table? please help, im really not sure how to do it Here's my sample data: Data Table( "Analgesics" ) << Subset( Output Table( "dt_subset" ), By( :gender ), All rows, Selected columns only( 0 ), colu...
UserID16644

Discussions |
Nov 2, 2021 4:00 AM

911 views | 1 replies
Understanding the meaning of a lift curve

I'm trying to understand the meaning of a lift curve. If it starts very high (>4) but drops to 0 after .1 does that mean there is no predictive power for 90% of the population?
hilarywsilver

Discussions |
Nov 1, 2021 10:31 AM

3343 views | 3 replies
How to refresh data table from SAS

How to refresh data table from SAS?Usually people refresh data from Excel but I'd like try to refresh data from SAS.I follow below step but not success.source -> right click --> run script. (I'm sure that I already connect with SAS service, login successful)
collin

Discussions |
Nov 1, 2021 8:57 AM

792 views | 1 replies
JMP 16.1 > GraphBuilder > Binary Categorical Variable (0,1) > Bar Graph: How do I get the bars to span the range of % instead of a simple line?

Hi JMP Community, I recently upgraded JMP to version 16.1 (Windows), and I tried to rerun saved GraphBuilder bar plots where Y is a binary categorical variable (0,1), and X is also a categorical variable. In JMP 14.1, these GB scripts would yield full bars with a floor at 0 and a top at the frequency of 1's as shown below. Now, when I try to reproduce these plots in JMP 16.1, I get the followin...
Thierry_S

Discussions |
Nov 1, 2021 8:18 AM

1850 views | 5 replies
How to use JSL to save T² from PCA platform (or how to calculate it)

Hi All, I am trying to get some JSL code working to save T² from the Principal Component platform, like how you can do it by calling <<Save DModX(n), where n is the number of PCs to use. I know that the call << Save T Square will work with multivariate control chart, but it doesn't seem to work with the PCA or Multivariate platforms. I need to use the PCA platform to generate the T² formula be...
SDF1

Discussions |
Nov 1, 2021 6:10 AM

2000 views | 8 replies

Previous
Next

Latest Discussions

How to refresh data table from SAS

How to refresh data table from SAS?Usually people refresh data from Excel but I'd like try to refresh data from SAS.I follow below step but not success.source -> right click --> run script. (I'm sure that I already connect with SAS service, login successful)
collin

Discussions |
Nov 1, 2021 8:57 AM

792 views | 1 replies
Remake JMP Neural Net in Python

So I have a neural net in JMP that has a 0.7 R2. I need to deploy this model to my website so I need some sort of cloud solution. I thought I could just remake the Neural Net in Python. But really struggling to get the settings I guess.....any suggestions
VeryData

Discussions |
Oct 29, 2021 1:00 PM

876 views | 1 replies
How to quantitatively compare particle distributions??

Ok, so I have a large data set that has particle size distributions (surface area for each particle in the sample) for over 100 samples and I need a way to quantitatively (or semi-quantitatively) compare them to the whole data set or sort into groups with similar distribution characteristics. The vast majority of the points are in the very small size fraction but due to the very small size do not...
seismicfish

Discussions |
Oct 29, 2021 11:08 AM

3358 views | 9 replies
Model Selection-stepwise

Hello, I have screened a series of biological parameters on a biological response with a DSD. I am doing a forward stepwise regression AICc, and at p value below 0.05, I see only one or maximum two of my parameters become significant, but beyond that (like at around 0.1 or 0.2), several others pop out as significant, and if I remove them, the R square value decreases. In some models I do not see e...
_Luci_

Discussions |
Oct 29, 2021 7:23 AM

1911 views | 6 replies
Global Zip codes. Best done in JMP or SAS?

ISO has standards for zipcodes around the world. Is this feature available in JMP, SAS or Both.I guess since this is a JMP forum, I should limit this to JMP. Here's the ISO standard, https://en.wikipedia.org/wiki/ISO_3166-2 China I need to map. China has prefectures but they have these subvisions at the local level.Also, is there a way to list both chinese simpllified, chinese traditional, romaniz...
Residentx

Discussions |
Oct 29, 2021 12:52 AM

1996 views | 6 replies

Previous
Next

Latest Discussions

Variability Chart Platform Factor Re-Insert Positions (Not Swapping)

Hello JMP Community, I understand dragging between any two factors swaps the location pairs in the Variability Chart platform. Is there a way to drag to specifically re-insert the factors instead? For example, can I drag "Layout" between "Horizontal" and "Wafer ID" in the attached screenshot instead of performing multiple drags to have the intended result? I am aware I can do this reordering with ...
Technician

Discussions |
Oct 26, 2021 11:04 AM

798 views | 0 replies
how can I use structural equation model to make predictions?

Hi, I built a structural equation model and it works well. I would like use the model to make some predictions. Basically, what I want to do is to change the value of a variable and then JMP can calculate the values of other variables. Is there any way i can output the model equation so that I can use it to predict? Thanks.
lujc07

Discussions |
Oct 22, 2021 11:54 AM

547 views | 0 replies
Get (x & y) intercept values from linear fit of the linear region of a curve/data and store them in a new column

I have JMP data table with data from several parts for which a Capacitance 'C' has been measured as a function of reverse voltage 'V' (0 to -5 V in -0.1V step). A plot of [1/C]^2 vs V has a linear part for small reverse bias (say from 0 V to -0.5V and data is available at 0, -0.1, -0.2, -03, -0.4 -0.5 V within this range). How to do a linear fit to the points between 0 to -5V for each part, extrac...
Neo

Discussions |
Oct 22, 2021 10:15 AM

555 views | 0 replies
Debugger report for finding bottlenecks

I'm trying to find bottlenecks in a large script with many includes. I can run the debugger to profile the script but I'm wondering if there's a better way than just looking through each included script for the highest number. I'm imagining a pareto. Anyone know a good method to analyze script performance?
vince_faller

Discussions |
Oct 22, 2021 7:31 AM

476 views | 0 replies
world map server compatibility

I have successfully used 1-2 world map servers in the past through GraphBuilder but am encountering issues recently (JMP Pro 16). I can't figure out if it's something on my/JMP's end, or the WMS themselves. For instance, the US government has all these presumably WMS-like mapping products: Note: tiled services may show up as Web Map Tile Service (WMTS), rather than WMS. Most software that can loa...
abmayfield

Discussions |
Oct 22, 2021 4:56 AM

543 views | 0 replies