JMP User Community

Latest Discussions

Difference despite same numbers...

Hello, Today I have a non-understanding question.I have 2 columns of products prices. I wanted to check that same numbers are the same in the 2 columns so I created a formula column with the formula If( :"Mean(Final Price)"n != :prixLot / 100,
"Yes",
"No"
) Even if same number was in the 2 columns (exactly the same including decimals) then the formula returned me a "Yes". So I did difference column: ...
mgerusdurand

Discussions |
Oct 9, 2023 5:10 AM

1224 views | 2 replies
How to filter rows of a data table with dynamical number of conditions?

Hi everybody, I would like to select rows based on the entries of selected rows from another table. Below a code snippet. The last row is not valid, but it should clarify what I mean. selected_row_idx = DT << Get Selected Rows; measurement_starts = DT:MeasurementStart[selected_row_idx]; measurement_ends = DT:MeasurementEnd[selected_row_idx]; DTmeas << Select Where(measurement_starts[1] <= :TimeSt...
Robbb

Discussions |
Oct 9, 2023 2:27 AM

1674 views | 2 replies
How do I filter categorical data that does not meet my location restriction?

Hi, I am doing a project that involves getting a model ready from airbnb listing data to the predict price of Broward County airbnb listings. I am trying to exlude and hide rows within my data that are not in Florida as there are many listings that are from different countries and states. Is there a way to do this without having to go row by row? This is categorical character data.
jmessina944

Discussions |
Oct 8, 2023 6:37 PM

1654 views | 4 replies
Do Not Open CSV File after 'Save As' when scripting

Hi, I need to save tables by scripting both as .csv and then as .jmp.When the .csv table is saved, it is automatically opened in excel (Win 11, JMP17Pro). Is there a way to set an option (or preference) to prevent the behavior? Thanks Sebastien
Sburel

Discussions |
Oct 8, 2023 1:40 PM

1868 views | 3 replies
Newb Question - Basic Sequencing in a column

I'm a beginner in JMP and coding as a whole. I'm trying to figure out how I can make sequence of 0, 25, 50, 100, to repeat 8 times. I tried Sequence(0,100,25,8) and obviously 75 shows up as well. And I cannot for the life of me figure it out. Chatgpt gave me the following code: If(Mod(Row(), 4) == 0, 0, If(Mod(Row(), 4) == 1, 25, If(Mod(Row(), 4) == 2, 50, If(Mod(Row(), 4) =...
ControlAlpaca51

Discussions |
Oct 8, 2023 1:06 PM

1475 views | 3 replies

Previous
Next

Latest Discussions

How do I filter categorical data that does not meet my location restriction?

Hi, I am doing a project that involves getting a model ready from airbnb listing data to the predict price of Broward County airbnb listings. I am trying to exlude and hide rows within my data that are not in Florida as there are many listings that are from different countries and states. Is there a way to do this without having to go row by row? This is categorical character data.
jmessina944

Discussions |
Oct 8, 2023 6:37 PM

1654 views | 4 replies
Newb Question - Basic Sequencing in a column

I'm a beginner in JMP and coding as a whole. I'm trying to figure out how I can make sequence of 0, 25, 50, 100, to repeat 8 times. I tried Sequence(0,100,25,8) and obviously 75 shows up as well. And I cannot for the life of me figure it out. Chatgpt gave me the following code: If(Mod(Row(), 4) == 0, 0, If(Mod(Row(), 4) == 1, 25, If(Mod(Row(), 4) == 2, 50, If(Mod(Row(), 4) =...
ControlAlpaca51

Discussions |
Oct 8, 2023 1:06 PM

1475 views | 3 replies
How to get non-duplicate column names from the "leaf label formula" of decision tree model?

For example, use the following JSL to get the Leaf Label Formula.Extract the column names from the formula in the first 10 rows.Thanks!d0 = Open( "$SAMPLE_DATA/Equity.jmp" ); p=Partition( Y( :BAD ), X( :LOAN, :MORTDUE, :VALUE, :REASON, :JOB, :YOJ, :DEROG, :DELINQ, :CLAGE, :NINQ, :CLNO, :DEBTINC ), Validation Portion( 0.3 ) ); p<<go;Wait(2); p << save leaf label formula;
lala

Discussions |
Oct 7, 2023 8:02 AM

1262 views | 3 replies
for each group find out which value is missing in a specific column, then create a new row with the missing value for that group with 0 in the count column as a corresponding value for that row

I have 4 columns in the mock data set (File attached below). The column "Companys" is grouped by column "Month-Year" and "State". Each "Companys" column value is associated to a value in column "Sectcor". I want find what values are missing in each group of Month-Year and State Column for example Sector "DK" has Companys "C" and "D" Associated to it but for group Jan-2021, CA we have 2 rows associ...
j0rg

Discussions |
Oct 6, 2023 1:54 PM

1357 views | 1 replies
REML analysis / Iterations Converged in the Gradient

What is the significance of the statement "Iterations Converged in the Gradient" in the Iterations output within the REML Variance Component Estimates Report? Also, what is the impact on using this REML analysis to evaluate residual error if the iterations do not converge in the gradient? Is this an indication that the dataset was not amenable to the analysis? Thanks!
dwillingmyre

Discussions |
Oct 6, 2023 8:50 AM

1200 views | 1 replies

Previous
Next

Latest Discussions

Strange behavior using GenReg and Forward Selection

Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
SDF1

Discussions |
Oct 2, 2023 9:06 AM

618 views | 0 replies
SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
CamillaLiscio

Discussions |
Oct 2, 2023 5:55 AM

1124 views | 0 replies
What determines which data table is seen as "Associated Data" for New Window?

What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi

Discussions |
Sep 21, 2023 9:44 AM

733 views | 0 replies
Using R - File path problem

I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus

Discussions |
Sep 17, 2023 10:46 PM

848 views | 0 replies
Data Access Handler

How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi

Discussions |
Sep 16, 2023 12:21 AM

560 views | 0 replies