JMP User Community

Latest Discussions

Extract text from string

Hi,If possible I would like extract particular text from the strings:\\swirt.misc@CAS-K-CLERK\K10447-Wit_OG lo hi TT-YYT (CTL1083.1)_172-7-10053 -303\\swirt.misc@CAS-K-CLERK\K10445-Wit_OG lo hi ES WERT (CIL0858.1)_172-7-10046-600\\swirt.misc@CAS-K-CLERK\K10437-Wit_OG lo hi TT-YYT (CTL1077.1)_172-7-10053-303\\swirt.misc@CAS-K-CLERK\K10420-Wit_OG lo hi ES TRTR (CMA0851.1)_172-7-10047-600\\swirt.misc...
swiergi11

Discussions |
Jan 12, 2022 8:12 AM

10164 views | 11 replies
Missing Specification Limits in Levey Jennings Control Charts

Dear Community, For the process performance reports my colleagues and I create via JMP, we include a Levey Jennings control chart figure. We create this figure using the "Analyze"->"Quality and Process"->"Control Chart"->"Levey Jennings"-tool Oddly enough, even tho we specify the specification limits for the column(s) (and check the "show as Graph Reference Lines"), the figure will only show the c...
N_Faust-BC

Discussions |
Jan 12, 2022 5:33 AM

2694 views | 4 replies
How to add lines (specs, targets) to a histogram in graph builder while using local data filter?

I have a lot of data (> 6,000) in one column for many different products. In another column I have product name and, in total, 12 different products covering these > 6,000 data.In graph builder I can make a basic histogram of all data and then use local data filter to see a histogram of the data only for the product selected. This works nicely but is incomplete because I want to view each histogra...
scottahindle

Discussions |
Jan 12, 2022 4:42 AM

5284 views | 4 replies
creating a map of cell by cell value

Hi JMPers,I'm trying to create a plot of column Z by a matrix of X & Y, (X & Y have discrete values, Z is continues).was only able to create contour plots but I'm trying to get something like this: does anyone have an Idea?would love a solution in a script format....
Boaz

Discussions |
Jan 12, 2022 1:12 AM

2067 views | 4 replies
How to extract the position of a char in a string?

I have the following column, which contains string of char, such as dot or char (no number and special char).I want to generate a column that list out the position of the char which is not a dot. See an example below.Is there any formula or script I can use in JMP?? ·cgaagt··a··········· 2,3,4,5,6,7,10
··t·a·············c·· 3,5,19
·····················
JMP2021

Discussions |
Jan 11, 2022 11:15 PM

2610 views | 2 replies

Previous
Next

Latest Discussions

Missing Specification Limits in Levey Jennings Control Charts

Dear Community, For the process performance reports my colleagues and I create via JMP, we include a Levey Jennings control chart figure. We create this figure using the "Analyze"->"Quality and Process"->"Control Chart"->"Levey Jennings"-tool Oddly enough, even tho we specify the specification limits for the column(s) (and check the "show as Graph Reference Lines"), the figure will only show the c...
N_Faust-BC

Discussions |
Jan 12, 2022 5:33 AM

2694 views | 4 replies
How to add lines (specs, targets) to a histogram in graph builder while using local data filter?

I have a lot of data (> 6,000) in one column for many different products. In another column I have product name and, in total, 12 different products covering these > 6,000 data.In graph builder I can make a basic histogram of all data and then use local data filter to see a histogram of the data only for the product selected. This works nicely but is incomplete because I want to view each histogra...
scottahindle

Discussions |
Jan 12, 2022 4:42 AM

5284 views | 4 replies
How to extract the position of a char in a string?

I have the following column, which contains string of char, such as dot or char (no number and special char).I want to generate a column that list out the position of the char which is not a dot. See an example below.Is there any formula or script I can use in JMP?? ·cgaagt··a··········· 2,3,4,5,6,7,10
··t·a·············c·· 3,5,19
·····················
JMP2021

Discussions |
Jan 11, 2022 11:15 PM

2610 views | 2 replies
Cast selected columns into roles not showing

I have a trouble with JMP16, hopefully someone has encountered and overcome this problem.While choosing commands, Cast selected columns into roles in Multivariate and correlations, the selected options are invisible. In other words command select the columns into roles, when i click on column name, then click Y,columns, the option doesn't display at all. Surprisingly it seem to invisibly select th...
JustineK

Discussions |
Jan 11, 2022 11:02 PM

953 views | 1 replies
Summary and Sorting - Sorting not working

I have a data table where I am wanting to calculate mean, and have the output sorted (Descending) from a grouped column. As an exampleI.e., Data table If I summarize as follows:Data Table( "Example_DT" ) << Summary(
Group( :i, :f, :g, :h ),
Order( Descending, Descending, Descending, Descending ),
Mean( :Values ),
Freq( "None" ),
Weight( "None" )
);i.e., Selecting Descending Output is incorrect: Sho...
justvince

Discussions |
Jan 11, 2022 3:03 PM

2207 views | 4 replies

Previous
Next

Latest Discussions

How do I apply time fixed effects with multiple regression

I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function only available in SAS? Thanks
RiDe

Discussions |
Jan 10, 2022 11:18 PM

706 views | 0 replies
separating labelled values from graph points

I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...
Cdougz

Discussions |
Dec 31, 2021 7:38 AM

915 views | 0 replies
Expand Contours

Hi,

I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks!
MikeDereviankin

Discussions |
Dec 15, 2021 12:49 PM

712 views | 0 replies
Getting all Zeros for the AR(1) estimate/std error in a Repeated Measures Mixed Model Using JMP Pro

I am fitting a model of a continuous response against 7 fixed effects. When running the Standard Least Squares; my residuals plots/assumptions checks don't look too bad but the Durbin Watson test is suggesting an AR(1) structure in the residuals. This is expected for this particular analysis and is consistent with other data sets looking at the same response/factors. The Time Series platform also ...
lisa2442

Discussions |
Dec 14, 2021 7:32 AM

874 views | 0 replies
Export Functional Data Explorer prediction formula

Hi,I want to export the prediction formula generated by Functional Data Explorer either to Excel or Python (via Formula Depot), but there is a problem because the formula contains P Spline Coef() interpolation, which I think is not available in Excel or in Python libraries. Do you have any suggestions how to solve this?Best regards
ruskicar

Discussions |
Dec 14, 2021 2:11 AM

832 views | 0 replies