JMP User Community

Latest Discussions

Open old JMP Genomic scripts in JMP Pro

Hi, I am transitioning from running microarray data in JMP Genomics to JMP Pro. I have hundreds of old analysis output scripts that I revisit but I noticed that if I try to open a script (e.g. ANOVA Script for data_amr.jsl) in JMP Pro 17 I get the error message "The namespace "jg" is not defined in access or evaluation of 'jg:cutoff', /*###*/". I guess it is because all these scripts are linked to...
JeandO

Discussions |
Oct 13, 2023 9:58 AM

1958 views | 2 replies
Using variables in column formulas

I want to change all references to "AGC EXP101P 2" to the variable 'colname' so that when I run the script this code applies to the selected column in the data table and not just the column "AGC EXP101P 2". However, when I try to change it, JMP always reads the variable name as a string in the column formula and doesn't evaluate properly. How do I fix this so that the column formula recognises the...
CriticalMarten1

Discussions |
Oct 13, 2023 8:05 AM

1099 views | 1 replies
Database access

Hi, when I generate a Database Query via the GUI in Jmp, how can I use advanced SQL functionality?SQL formulas (rand (),txt = Substring(), myValue = a+b )ExplodeLateral View
hogi

Discussions |
Oct 13, 2023 6:58 AM

1901 views | 4 replies
Delete object reference in SQL custom query - JMP 17

Hi,I am trying to query data base by providing input parameter through a variable. 1] I am seeing below error for attached:a = 666.1;
deleted object reference[] How do i resolve this? It works when I use 666.1 directly here FROM fer_view2 t1 where(t1.DVT_id = 666.1) a = 666.1; show(a); obj = New SQL Query( Connection( "ODBC:DSN=DVT Data Server" ), QueryName( "fer_view2" ), CustomSQL( "SELE...
vharibal

Discussions |
Oct 13, 2023 2:49 AM

1287 views | 2 replies
How can I make a graph from data in multiple data tables without physically joining the tables?

I have 2+ data tables with the same columns and I want to produce a graph using all the tables. Previously, I have concatenated them and used the resulting table however this produces lots of extra tables. Is there a way to essentially concatenate them without physically creating a new table?( Also, want to automate this process if possible.)
MedianRooster10

Discussions |
Oct 13, 2023 2:05 AM

2083 views | 3 replies

Previous
Next

Latest Discussions

Open old JMP Genomic scripts in JMP Pro

Hi, I am transitioning from running microarray data in JMP Genomics to JMP Pro. I have hundreds of old analysis output scripts that I revisit but I noticed that if I try to open a script (e.g. ANOVA Script for data_amr.jsl) in JMP Pro 17 I get the error message "The namespace "jg" is not defined in access or evaluation of 'jg:cutoff', /*###*/". I guess it is because all these scripts are linked to...
JeandO

Discussions |
Oct 13, 2023 9:58 AM

1958 views | 2 replies
Export Over 200 Graphs from Graph Builder

I am trying to display and/or export close to 900 graphs from a dataset using Graph Builder using JMP Pro 17.0.0 into a PowerPoint or pdf format. However, it seems like 200 graphs is the maximum JMP will display or export. Am I missing something to display/export them all or is there a preference I can toggle to allow more to be displayed/exported? Thanks!
FactorBiasFawn3

Discussions |
Oct 12, 2023 9:51 PM

798 views | 1 replies
analysis of fit to cosine wave

I am planning to analyze circadian rhythm data and can fit it to the Savitzky-Golan smoother with a cubic degree and local cosine weighting. This provides a visual with a confidence of fit. However, is there a way to statistically determine the quality of the fit to the cosine waveform? I have tried saving the smoother formula to the data table then launching the analysis using the upper and low...
aadecarlojr

Discussions |
Oct 12, 2023 7:32 AM

1561 views | 2 replies
Categorical heatmap?

I'm trying to find a way to combine the two wafer maps below. In other words, I need the X/Y coordinates to actually appear as rectangular die areas on a wafer, like in the heatmap below (not as points), AND have the legend to be discreet and maybe customized colors like in the point map below (not as a continuous gradient from 0-4). Is there any way to combine these features? TIA! Heatmap: Point...
belikin23

Discussions |
Oct 12, 2023 4:30 AM

2152 views | 5 replies
Adjust only the hour values in DD-MM-YY H:M:S

HI JMP users, I have a column that contains data in the format DD-MM-YY H:M:S (screenshot attached below), and I would like to adjust only the hour values to make them even. For example, I want to change a time like 13-07-2023 15:00 to 13-07-2023 16:00. Is there a method to modify only the hour values across the entire column? Regards,
chandankishor66

Discussions |
Oct 12, 2023 1:43 AM

871 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

610 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

1111 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

729 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

840 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

556 views | 0 replies