JMP User Community

Latest Discussions

Refer to Columns in other Data Table using Formula in Column Names

I have a data table with column names having xy coordinates embedded in them. something like "delay [x,y]" I'd like to use a list of [x,y] (attached) to construct the column names so I can refer to a specific column in that table. When I tried to do subtractions referring to the column using dt:name() it errored out "Name arg must be quoted string". Any suggestions? list=xy<< get column names(...
midori555

Discussions |
Nov 18, 2021 7:36 PM

935 views | 1 replies
Multivariate Nominal Logistic Regression- Prediction Expression

I am using the Fit Model platform to fit three continuous variables to a binary outcome. There is an option to "Save Probability Formula" which then outputs onto my original data data, and then populates probabilities and then classifications when I input new rows of data for my three variables. However, I do not see an option to Show Prediction Expression. e.g. Variables: Temperature, Len...
Shujinko

Discussions |
Nov 18, 2021 5:57 PM

1161 views | 2 replies
JMP 16 Get Script

I am used to getting a data table all setup for how I want columns and formulas in my data table, then running a get script to get all the columns and formulas I added. E.g., dt = current data table(); dt << Get Script; After the script is run I copy from the log the new columns I added, pasting into a new script and when I pull new raw data, I can then just run the script to add the columns an...
justvince

Discussions |
Nov 18, 2021 1:12 PM

1929 views | 4 replies
Controlling the .jmp suffix at end of table names

Hi. Does anyone know how to control if the ".jmp" extension appears at the end of your table name when opened? I've noticed when I open some tables it's there, but on other tables, not. I do not know why. I'm writing a script that uses the table name and I need it to be consistent. Is there a preference I can use to control it, or some command? I have considered just arbitrarily stripping th...
nikles

Discussions |
Nov 18, 2021 11:48 AM

715 views | 1 replies
User Input List for Regression Report with Interactions

I have an input box where users can select columns to be run in a regression report. This part works great. I then insert the list of columns into a list. I would like to take the list of columns and make different interactions that can be inserted into a regression report. Specifically, I am interested in slightly more complicated interactions (i.e. Column 1 * Column 2 ^2) When I try to put anyth...
dkraeuter_sunne

Discussions |
Nov 18, 2021 10:51 AM

1592 views | 5 replies

Previous
Next

Latest Discussions

Controlling the .jmp suffix at end of table names

Hi. Does anyone know how to control if the ".jmp" extension appears at the end of your table name when opened? I've noticed when I open some tables it's there, but on other tables, not. I do not know why. I'm writing a script that uses the table name and I need it to be consistent. Is there a preference I can use to control it, or some command? I have considered just arbitrarily stripping th...
nikles

Discussions |
Nov 18, 2021 11:48 AM

715 views | 1 replies
Rotate MAP North South

Hello,

Does JMP have the capability to rotate a map North/South as oppose to simply using Lat Longs? If I have a SHP file within this map would that rotate as well?

Thanks!
MikeDereviankin

Discussions |
Nov 18, 2021 9:07 AM

1117 views | 3 replies
How to remove quotation marks from the result of Concat command

Hi all, I am trying to concatenate the content of the row with the parsed characters of its previous rows: Word( 1, :Col1[Row() - 1] || "-" || Words( :Col1, "-" )[2] ) Col1 has the following two rows: ABCD123-1 ABCD123-2 It results the following: "ABCD123-1-2" How can I remove the quotation marks sow it shows the following ABCD123-1-2
ardavanz

Discussions |
Nov 17, 2021 1:29 PM

1084 views | 1 replies
Importing CSV makes an empty table

Hi- I'm following the import steps described here https://www.stat.purdue.edu/~lfindsen/stat511/01_importing_text_files.pdf and for some reason my tables are empty except for column names. I've tried different character sets (best guess, ASCII-US, macintosh) but the data fields are always empty. I import files often, usually excel, but I'm at a loss as to why this is happening.
TC2

Discussions |
Nov 17, 2021 10:51 AM

872 views | 1 replies
Axis Setting in %

Hi, Great day. I imported data from Excel, however the data in percentage auto-converted to number in decimal places. I wonder how I can present them in % in the graph. My axis setting (Fig 1) is different from what is shown in the Help page (Fig 2). How could I get there/ how to change them into better axis? Thanks a lot! Fig 1: Axis setting in my computer Fig 2: Axis setting in Help Pa...
Shinyi

Discussions |
Nov 17, 2021 8:00 AM

810 views | 2 replies

Previous
Next

Latest Discussions

Can I share dashboard with specific person in JMP Public?

Hi, I would like to share my dashboard in JMP Public. However, there are only two choices: "only share with me" and "share with everyone". Is there anyway to share with specific persons? Thanks.
lujc07

Discussions |
Nov 9, 2021 7:41 AM

529 views | 0 replies
Changing axis scale with superscripts

I'm wondering how to change my axis scale with superscripts. I am using unicode font to write the superscripts but I am having trouble applying the superscripts to my axis. I want the minimun to be 10⁻¹⁰ and maximum to be 10⁻³. I have attached scrrenshots below of what I'm stuck on. I'm thinking I need to use a custom format but I can't figure it out. Y axis scale needs to be LOG.
hannahmcnamara

Discussions |
Nov 7, 2021 1:02 PM

485 views | 0 replies
Predictive Modeling Using JMP Pro is Scheduled!

The Predictive Modeling Using JMP Pro course is scheduled in the Live Web classroom 1:00 pm to 4:30 pm EDT, Monday-Thursday, 11-14APR2022. Learn how to build and understand predictive models such as generalized regression models, support vector machines, naive Bayes, decision trees, and neural networks. We'll also compare complex models and score new data in JMP. Click here for the course page and...
KathyKiraly

Discussions |
Nov 5, 2021 6:50 AM

573 views | 0 replies
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

800 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

548 views | 0 replies