JMP User Community

Latest Discussions

How to efficiently parse structured text strings of varying number of elements

Happy New Year Everyone! I started exploring this dataset from Kaggle: https://www.kaggle.com/chicago/chi-restaurant-inspections. Each row is a restaurant inspection, with a single column for list of violations. Thankfully, the violations are delimited by "|". Sample below. The number of violations varies. 40. REFRIGERATION AND METAL STEM THERMOMETERS PROVIDED AND CONSPICUOUS - Comments: STEM THER...
markschahl

Discussions |
Jan 8, 2018 10:28 AM

6321 views | 3 replies
JSL scripts - comments and blank space disappear after running/pasting

Hello All, I have a fairly long JSL script (~500 lines). It collects user input and then creates graphs from the table of data the script is in. I have been encountering a bizarre problem however. Sometimes after running the script using the green arrow in the script window (not the "run" button with the editor open), when I open the script back up all the comments and blank spaces I had in the sc...
Cwalla

Discussions |
Jan 8, 2018 7:59 AM

7724 views | 3 replies
Invert Col Rank Functionality

All, Is there a way to invert Col Rank() functionality especially when using with a By Variable i.e. by default Col Rank() assigns 1 the lowest value in the group. However, I would like it to assign "1" the highest value similar to the Sort Argument allowing a "descending" flag.
uday_guntupalli

Discussions |
Jan 8, 2018 7:49 AM

5449 views | 2 replies
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

15844 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

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