JMP User Community

Latest Discussions

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

9348 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

5695 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

6436 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

17628 views | 9 replies
Change Control Chart Size (Aspect Ratio)

I copy control charts from JMP and paste to Word documents. In Jmp 12 and before the charts had a narrow height and wide width that was condusive to pasting two charts on each page. In JMP 13 the chart is much more square and does not use the width of the Word page efficiently. I am attaching two versions of the control charts for viewing. I would like help returning JMP 13 to the control chart as...
atlas100

Discussions |
Jan 4, 2018 11:27 AM

28346 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

2845 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

5480 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

16246 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

6811 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

4189 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

3481 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

2390 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

2496 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

3130 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

4101 views | 0 replies