JMP User Community

Latest Discussions

How to write multiple 'Contains' in SQL query

Hello everybody. Let's say I have an array with strings that are values of rows that I need to pull from DB. Let's say the array is:searchStringArray = {'qwe', 'rty', 'asd',' fgh', 'zxc'}I can construct my WHERE statement in my query in a pretty simple way:"WHERE t1.column1 IN (' " || Concat Items(searchStringsArray, " ', ' ")|| " ' )"which when parsed would give me the following string:"WHERE t...
miguello

Discussions |
Jun 7, 2019 10:29 AM

22538 views | 4 replies
Change Values in a Column to UpperCase

Question: I have a data table with data values in upper and lower case text strings in one column.I expect that the code will need to loop through each row, select the column of interest and set the value in the column to uppercase. I am having an issue figuring out the correct syntax to do this. This is what I have so far, but don't think I am close enough. Thanks to any help that can be provide...
JensRiege

Discussions |
Jun 7, 2019 10:11 AM

11385 views | 6 replies
Questions on Survey Analysis

Hi All, I am working on the survey data in JMP (Analyze --> Consumer Research --> Categorical) and i wanted to get your advise on the below 1. How to hide rows/columns in the survey output table ?
2. Is it possible combine two variables ? If yes, how can i do it ?
3. In the survey output table, if i have a supercategory in the 'Top' variable , it doesnt show up in the 'survey output table'. How ca...
Ravi814

Discussions |
Jun 6, 2019 8:23 PM

3780 views | 3 replies
Multiplying multiple columns one by one

I have 20 columns of data. I need to multiply each column with all of the other columns - one by one. For example, column 2 * column 3; column 2 * column 4; column 2 * column 5...column 3* column 4, column 3 * column 5...Is there an easy way to do this with JMP? Thanks for your help, Jess
Jess

Discussions |
Jun 6, 2019 10:56 AM

3898 views | 2 replies
JSL for SQL

Good morning,Attached is a script I wrote that accomplishes what I need.Basically it creates pairs out of sequential (left to right) cells, going from (1,2), (1,3), ..., (1, k), (2, 3), ..., (k-1, k)Then it stacks them and labels them.Does anyone know how to accomplish the same in SQL.Thanks in advance!Sincerely,MG
GM

Discussions |
Jun 6, 2019 10:40 AM

3390 views | 2 replies

Previous
Next

Latest Discussions

Questions on Survey Analysis

Hi All, I am working on the survey data in JMP (Analyze --> Consumer Research --> Categorical) and i wanted to get your advise on the below 1. How to hide rows/columns in the survey output table ?
2. Is it possible combine two variables ? If yes, how can i do it ?
3. In the survey output table, if i have a supercategory in the 'Top' variable , it doesnt show up in the 'survey output table'. How ca...
Ravi814

Discussions |
Jun 6, 2019 8:23 PM

3780 views | 3 replies
Multiplying multiple columns one by one

I have 20 columns of data. I need to multiply each column with all of the other columns - one by one. For example, column 2 * column 3; column 2 * column 4; column 2 * column 5...column 3* column 4, column 3 * column 5...Is there an easy way to do this with JMP? Thanks for your help, Jess
Jess

Discussions |
Jun 6, 2019 10:56 AM

3898 views | 2 replies
Windows10: Have to press ALT key twice to access file menu with keyboard, and keyboard commands generally slow to respond

I am using JMP 14.0.0 64-bit on Windows10.Keyboard commands are all slower to respond than I expect (for instance CTRL+W to close the Column Info window takes ~1 second), and to get the file commands activated I have to type the ALT key twice when I switch to a window for the first time. For instance, if I ALT+TAB to Excel, then ALT+TAB back to JMP, and press ALT, nothing happens. If I press ALT...
JT383

Discussions |
Jun 5, 2019 9:56 AM

3165 views | 3 replies
Updating data from one jmp table to another jmp table

Hi All,i have written a script where , i will be creating several columns in JMP table (Say table-1) based on some calculation. Now i want to populate few selected Row and columns of Table-1 to another JMP table (say table-2). I need help in populating the second table with selected Rows and coloumns. Kindly suggest. Regards,Dilip
dilipkumar

Discussions |
Jun 4, 2019 4:28 AM

2594 views | 1 replies
Running Jupyter Notebook from JSL

I'd like to run a Jupyter notebook from a JSL script. I tried the following but without success: //================================================================ // Open Jupyter notebook // RunProgram( Executable( "C:/Users/Owner/Anaconda3/Scripts/jupyter.exe " ), Options( {"notebook", "C:/temp/meteorites.ipynb"} ), Read Function( "text" ), ); //===============================================...
waltp

Discussions |
Jun 3, 2019 6:28 AM

6625 views | 5 replies

Previous
Next

Latest Discussions

Help understanding how Lift curves are calculated

Dear JMPers, (computer details: I have JMP Pro 14 on a W7 Enterprise, 64-bit computer.) I am trying to better understand how JMP actually calculates a Lift curve. I understand conceptually the ROC and Lift curves, but I'm having a hard time calculating a Lift curve myself. The JMP help/support page (https://www.jmp.com/support/help/14-2/lift-curve.shtml#1276958) isn't all that helpful in under...
SDF1

Discussions |
May 29, 2019 11:10 AM

2072 views | 0 replies
How to analyze PSM data(Propensity Score Matching) in JMP？

How to analyze PSM data(Propensity Score Matching) in JMP？If it is yes, please tell me what detail steps in JMP manu,If there is any available examples in JMP sample data?
mujahida

Discussions |
May 7, 2019 9:30 PM

2338 views | 0 replies
Chi square or Cochran's Q test

Okay, so i have to decide whether i should use chi-square or Cochran's Q test for one of my study.If i assume meat as experimental unit (EU) and impose 6 different wood smoke (like apple smoke, cedar smoke, hickory smoke etc.) on EU and consumers (people) act as observational unit (OU). I have 10 consumers and each one will taste each treatment (6 treatments) and respond liking (9 point scale), an...
sharmachetan

Discussions |
Apr 16, 2019 3:54 PM

3029 views | 0 replies
Selecting Number of Clusters in Hierarchical Clustering

One way to select possible number of clusters in hierarchical methods is to identify the relatively large changes in distance as number of clusters change (see table below). When I look at the actual distance measure from the table (clustering history below dendogram), there is a bigger jump from 3 clusters to 4 than from 4 to 5 (smaller), suggesting 4 may be the right decision. However, when you ...
pratyushdash

Discussions |
Feb 23, 2019 5:51 PM

3089 views | 0 replies
Beta Generalized Regression and adjusted chi-square values

I have a data set from a two-choice rodent feeding trial. We were testing the effectiveness of 10 deterrents by coating them on seeds and offering them to rodents alongside control seeds that were uncoated. The explanatory variable is which of the 10 deterrents the treatment seed was coated with, and the response variable is the proportion of control seed and treatment seed consumed. The question...
Mananahi

Discussions |
Feb 13, 2019 9:58 AM

2375 views | 0 replies