JMP User Community

Latest Discussions

Using Select Where in a script

Hello, I already looked around but couldn't find how to do this. This is what I am trying to do Data Table( "Untitled" ) << select where (contains(:column 1, "5_lbe/?")); Basically I have a bunch of data like this: 5_lbe12333, 5_lbe88837 (just to give an example) etc So it would be great if i could do it like in SQL with a SELECT LIKE statement but i cannot seem to find something similar in J...
kiza

Discussions |
Jan 7, 2018 11:29 PM

16869 views | 4 replies
where() clause with Contains() in Data Filter

Hi,When I try to do the following, I get an exception:
dt1 << Data Filter(
add Filter(
columns(:MyCol),
Where( contains(:MyCol, "A12") > 0)
),
mode(show(1))
) << invert row selection;

And I get the following exception:
The WHERE clause has not been correctly specified. in access or evaluation of 'Greater'

How to accomplish what the code tries to do properly?
vitali_pom

Discussions |
Jan 7, 2018 11:22 PM

10026 views | 2 replies
Combining For loop and Dispatch() command in a variability chart

Hello everyone, I am new to JMP and programming in general. My current challenge: I have a large data table with 800 columns. Now I would like to create box plots using the Variability Chart, but using a list, in which I first define which columns out of the 800 I would like to use. Then I create a For-loop as shown below. What is the proper syntax to get the concat to work? ThanksDatalist_log = {...
PS

Discussions |
Jan 5, 2018 9:58 PM

6569 views | 3 replies
Creating new columns with a For loop and giving each column its own name and formula

Hello everyone, I have a large data table with values and column headers test1,test2,test3,test4,...,test800. Some of these values are negative, and I would like to take all the columns I define in the list "Datalist_log_2" and create a new column called "test1_pos" with the absolute values. (For each test). Datalist_log_2 = {test1, test2, test5, test319}; wmax = N Items( Datalist_log_2 ); For (...
PS

Discussions |
Jan 5, 2018 12:37 AM

7251 views | 3 replies
Count the number of words in a string?

Can someone tell me the best function to count the number of a words in a particular string? For example, if I have a column of character data delimited by ";" or "," how do I count the number of "words" in that column, as defined by the particular delimiter? I know SAS has a function COUNTW that does this, but I can't find anything in JMP that will do it. Thanks in advance...
shahram

Discussions |
Jan 4, 2018 2:13 PM

20144 views | 9 replies

Previous
Next

Latest Discussions

What is different the result between effect tests table and effect leverage plot

Hi,I got the result of the parameter estimates & the effect test table by fit model.I used 5 factors and wanted to look the plot of each effect leverage.It is differernt the result value(estimates value, F-ratio, p-value) between two table and effect leverage.What is the reason?
mintkoko77

Discussions |
Jan 4, 2018 2:48 AM

3302 views | 1 replies
Implementing "Power Fit" Model in JMP and tuning the model

All, I have some data that fits well with the "Power Fit" in Excel. I found some helpful information in this post (https://community.jmp.com/t5/Discussions/Power-Fit-Equation-for-JMP/td-p/5783) I would greatly appreciate some more guidance on this topic: When the power fit is performed on the data in Excel - the fit seems fairly reasonableIn order to perform the power fit on the d...
uday_guntupalli

Discussions |
Jan 3, 2018 5:20 PM

6650 views | 4 replies
How to change range of Group Y data in Graph Buildfer

Group Y in a Graph Builder chart has grouped the data as ... 8-16, 16-24.... etc (Picture attached) whereas I want 20 to be a cut-off so that the effect can be shown of values <20 and >20. Is there a way to force JMP 13.2.1 to change the range, please? I have tried changing the 'Number of Levels..' but couldn't get 20 as the end of a range on Group Y. Thanks
abdul_saqib

Discussions |
Jan 2, 2018 6:47 AM

18313 views | 5 replies
Singularity details information from DOE data analysis

Dear JMPers, I encountered an issue, I got data from DOE, when I analyze these data in Fit Mode, then pump up an information of singularity details, I don't understand what happened to my DOE or data? why and how to solve this problem ? in order to present my problem, here I attached DOE data and my analysis here.Thank a lot in advance.
mujahida

Discussions |
Jan 2, 2018 1:51 AM

7601 views | 2 replies
How to stop JMP open file which was opened in a previous session

Hi, in JMP 13.2.1, I mistakenly said 'yes' to a message which has allowed JMP to open a file which I had opened in a previous session. Is there a way to stop JMP open the file on its own every time I start the software, please. Thanks
abdul_saqib

Discussions |
Dec 22, 2017 2:00 AM

4809 views | 2 replies

Previous
Next

Latest Discussions

Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3917 views | 0 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2802 views | 0 replies
Confirmation of Repeated Measures Analysis, when sphericity if voilated

Hi Everyone, I would like confirmation on the appropriate analysis to run on a repeated measures design.Experimental design:Independent variable: Nutrient treatment (Control, Low, Med, High),Dependent variable: basal diameter, 5 replicates (plants)Repeated measurements were taken at Weeks 0, 1, 4, 7, 10, & 12Split data-> Fit Model-> Y: basal 0, basal 1, 4, 7, 10, 12, Add: Nutrient treatmentPers...
uamiller

Discussions |
Oct 23, 2017 8:07 AM

2903 views | 0 replies
Cox Proportional Hazard - adjusting risk ratio with std dev

I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP. When I questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...
Maureen

Discussions |
Aug 22, 2017 1:18 PM

3513 views | 0 replies
JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4567 views | 0 replies