JMP User Community

Latest Discussions

Extract all desired elements from a string to enable multiple response analysis

Hi! I have data from a SharePoint which we use to (among other things) to track what tool/technique(s) was/were used to solve a problem. This includes JMP, BTW. The data (in one column) follow this type of ;-delimited formatting:

<technique description>;#<technique ID>;<technique description>;#<technique ID>;<technique description>;#<technique ID>...3.4 Offline Optimization & Simulation Tools;#15;...
markschahl

Discussions |
Oct 13, 2023 12:59 PM

4164 views | 9 replies
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

2283 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

1273 views | 1 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

1531 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

2424 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

2283 views | 2 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

1053 views | 1 replies
Loop through dates

Hi All,I am trying pull some data from the database by looping through dates, in this example, I am trying to loop from June until the date yesterday. This is my sample code. However, it is not working. Can someone explain how to properly do it? TIA d = Today() - In Days(1); dateNow = Format (d, "m/d/y"); startdate = "2023-06-01"; For( i = startdate, i <= dateNow, i++, try( dt = Open Database( "...
UserID16644

Discussions |
Oct 11, 2023 6:28 PM

1086 views | 1 replies
How to enter multiple repeating measurements in mixed model

I want to construct a mixed model in JMP pro 17 (on windows) with multiple repeating meaasurements as x-variables, but I'm only able to add 1 variable to the repeated structure window. Can someone help me how to fix this?
JM3

Discussions |
Oct 11, 2023 12:17 PM

903 views | 1 replies
Make combined data table with a column containing the test title

I need help with table scripting, I think... Goal: run paired tests on 93 variables and save the combined data table of results to apply a multiple-test correctionWhat's working: the analysis What I'm struggling with: the output of the combined data table. I'm looking for an output where, ideally, the two-tailed P value is included in the table with a descriptor column that relates back to the com...
Shiz

Discussions |
Oct 11, 2023 10:25 AM

2622 views | 5 replies

Previous
Next

Latest Discussions

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

871 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

657 views | 0 replies
Use JMP Locale Settings( 0 ) not working on macOS

It seems the following command does not work for JMP MacOS. Use JMP Locale Settings( 0 ) Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user? // Configuring JMP to save CSV as commas and not If( (Num( "3.14" ) == 3.14), is_EN_num_format = 1, //"English numeric format" is_EN_num_format = 0 //"Non-english"); )...
FN

Discussions |
Sep 15, 2023 10:21 AM

787 views | 0 replies
Exporting Graphs from Tab box to Excel cell

Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...
Jackie_

Discussions |
Sep 12, 2023 2:09 PM

826 views | 0 replies
PickFile() from within a Project does not use file filters

When I use PickFile() outside of a project, it works as noted in the scripting guide, scripting index, and other posts here in the forums. However, when I run the script within a project, the window that opens is a different one. It seems to be in order to allow you to pick a file that is saved to the project itself, but the filters do not work even though it shows the folder that I specified as d...
R2OKeefe

Discussions |
Sep 3, 2023 8:45 PM

1204 views | 0 replies