JMP User Community

Latest Discussions

Question about "word" formula, purpose to split one character and get key shorten word

I have one table with one column, name is "Batch ID", I want to use one script to generate one column, name is "Short ID", formula use Word( 2, :Batch ID, "L22DD1" ), only want to get 2nd word, for example, E3L22DD1K27--->K27, but how come after run JSL, its outcome is K2 not K27? kindly help to sugget whether have other solutions if it not work? Batch IDShort IDM3L22DD1K2K2E3L22DD1K45K45M3L22DD1K...
qspringleaf

Discussions |
Oct 22, 2020 2:16 AM

3401 views | 5 replies
Script to Save Residuals of Spline Fit

Hello, Anyone knows how to write a script to sava residuals (or predicteds) as a new colum for spline fit? It is easy if i do it manually, just need to select Save Residuals in the dropdown red triangle. I know how to write scripts to save residuals as a new column for liner fit using Fit Model. However, I often need to fit time-trend data using standardized x spline fit, and i am not sure if ther...
Peng

Discussions |
Oct 21, 2020 2:13 PM

11324 views | 9 replies
Count Sum of Repeat Occurrences By Specified Variable?

I would like to create a count sum formula which sums the number of occurrences of a value by a specified column variable.I want to know by a specified column variable value (i.e. Month) how many times did the same value appear in the column of interest.Example: Sum Type of Fruit By MonthNew Column ( "Count_Fruit_Mo", numeric, continuous, ...
aandw

Discussions |
Oct 21, 2020 11:48 AM

15546 views | 6 replies
How to close database connection after running a New Sql Query?

Steps to reproduce: Run any new sql query: query << Run Foreground( OnRunComplete( Write( "Number of rows in query result: ", N Rows( queryResult ) ) ) ); MyRunCompleteFunc = Function( {dt}, {Default Local}, Write( "Number of rows in query result: ", N Rows( dt ) ) ); query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );Next, if you try to delete the database, it will say that jmp ...
douglaschong

Discussions |
Oct 21, 2020 11:30 AM

2311 views | 1 replies
How to multiply user input by a constant number?

All, I'm trying to multiply user input number by a constant. I need to use the final number (hoursBack) as a part of a web address. local( {Name= "ABCD", daysBack = "7", formError = 1, rv}, While( formError > 0, formError = 0; rv = Dialog( Title( "Select Extract criteria" ), VList( HList( "Name:", Name= EditText( Name) ), HList( "Days Back", daysBack = EditText(...
shilpa

Discussions |
Oct 21, 2020 9:42 AM

4256 views | 5 replies

Previous
Next

Latest Discussions

How to close database connection after running a New Sql Query?

Steps to reproduce: Run any new sql query: query << Run Foreground( OnRunComplete( Write( "Number of rows in query result: ", N Rows( queryResult ) ) ) ); MyRunCompleteFunc = Function( {dt}, {Default Local}, Write( "Number of rows in query result: ", N Rows( dt ) ) ); query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );Next, if you try to delete the database, it will say that jmp ...
douglaschong

Discussions |
Oct 21, 2020 11:30 AM

2311 views | 1 replies
moving labels on GraphBuilder

I feel like this should be Graphbuilder 101, but I am stumped. So, I just want to make a couple of pie graphs and add the percentages as labels. But the labels are put in weird places, sometimes to where they can't be read. I thought you could actually manually drag text in some instances, but I failed there. I attached two scripts in the uploaded table ("test graphs"). Normally, you could just ad...
abmayfield

Discussions |
Oct 21, 2020 6:40 AM

4215 views | 3 replies
Subset data after filter

hello Everybody !I have a problem in my script.I have a big data table and i would like to subset some lines.I did a data filter and then subset or show subset, but i don't have "time" to select the filter in the window....how can i say in the script i have select first my filter and then subset the data tablei tried with a wait but it's not the best waythis is my script and i link my data basetha...
MargauxR

Discussions |
Oct 20, 2020 5:56 AM

1699 views | 1 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1196 views | 0 replies
Prior mean and prior variance matrix in choice design

Hi to all,I am just reading the article Optimal Design of the Choice Experiment - JMP BlogHere the author writes "When there are three levels in increasing utility order, enter negative, then 0." So far so good. But what if I have e. g. 5 prices like 5, 10, 15, 20, 25 and 30 euros. Which prior means would I take in that case?30 = -425 = -320 = -215 = -110 = 05 = 1And is the prior mean variance sti...
herberthinterbe

Discussions |
Oct 19, 2020 6:05 PM

17097 views | 6 replies

Previous
Next

Latest Discussions

Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1196 views | 0 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1480 views | 0 replies
order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! :)https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

1013 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

1137 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

1543 views | 0 replies