JMP User Community

Latest Discussions

Convert AM/PM time text to 24h time format - no JSL

Hi,I'm having trouble converting values like 08:49:46 PM
10:30:46 AMfrom Character Column to Numeric h:m:s 24h format.I would like to run the conversion without JSL and without depending on Operation system time format. Please assist.Regards,Tom.
tom_abramov

Discussions |
Jul 15, 2022 8:20 AM

16663 views | 9 replies
How do I copy and paste a value based on another column condition

hi,I want to copy the first row string and paste to all row of the net name column if they have the same group as the group 1 on the sample below thanks, grouppin typePinnet name1U4310011_BUMP_LKG_FH1U5310011_BUMP_LKG_FH1U3469971_BUMP_LKG_FH1U1469971_BUMP_LKG_FH1U2469971_BUMP_LKG_FH2U2468402_BUMP_LKG_1_FH2U246999U2_2_BUMP_LKG_1_LINK12U3468402_BUMP_LKG_1_FH2U346999U3_2_BUMP_LKG_1_LINK12U1468402_BUM...
VD

Discussions |
Jul 15, 2022 8:05 AM

1577 views | 2 replies
How to change the classification of Y axis?

Hello!For example, use this data table to map and categorize by country.
How to implement the Y-axis country sorting order is in the original order in the table?dt=Open("$SAMPLE_DATA/PopAgeGroup.jmp");
lwx228

Discussions |
Jul 15, 2022 6:40 AM

1452 views | 3 replies
Import from Excel: Numerical values removed

Hello dear community ! We compile our data in an Excel file and I created a script to automatically import the data from this Excel to JMP and setting up correctly the attributes of the columns. It always worked very well, but in the last update of the Excel template, one of the formula was slightly complexified (column "Calculated parameter" in the attached file), and every since, when I use the ...
Elofar

Discussions |
Jul 15, 2022 5:30 AM

2393 views | 3 replies
Predicting the effect of a process on a number of variables

Hi Everyone,I have a query that I'm hoping JMP and the community can resolve.I work with powders and powder rheology for additive manufacturing and use JMP to analyse rheology data. Most of our raw materials require a treatment to flow in the process, and I can see trends between the untreated and treated powders from the rheology data. I have a small dataset of powders before and after treatment,...
Richard_Davies

Discussions |
Jul 15, 2022 4:33 AM

1109 views | 1 replies

Previous
Next

Latest Discussions

Predicting the effect of a process on a number of variables

Hi Everyone,I have a query that I'm hoping JMP and the community can resolve.I work with powders and powder rheology for additive manufacturing and use JMP to analyse rheology data. Most of our raw materials require a treatment to flow in the process, and I can see trends between the untreated and treated powders from the rheology data. I have a small dataset of powders before and after treatment,...
Richard_Davies

Discussions |
Jul 15, 2022 4:33 AM

1109 views | 1 replies
Exclude selected columns

Hello, I get a varying list of columns from a source and select these columns in my data table. The data table has many other columns, but I want to hide/exclude the columns which are not in the list provided to me while my script is running and doing some analysis... I can select all the columns which I don't need by line below:dt < <invert column selection (Provided_List) Next step: Exclude thes...
aumair

Discussions |
Jul 14, 2022 10:44 PM

6620 views | 6 replies
Including multiple mixtures in a data table

Is there a way in JMP 16 to include multiple mixtures of variables in a data table? I have three "mixtures" that are independent of each other and the components of each total 100% of each mixture. All three mixtures are factors of the response I am investigating.
LargeChipmunk17

Discussions |
Jul 14, 2022 2:41 PM

1185 views | 2 replies
Prediction profiler does not work if formula contains row statement

Hi, I can't get the prediction profiler to display predictions if my formula contains a Row() statement. MWE: the Formula for Column5: :x works fine: while the formula for Column4::x[Row()] results in the prediction not being computed: Obviously I wouldn't need the Row() statement in the above MWE, but I've run into this problem while trying to build something somewhat more involved. I'm usin...
LukasKuerten

Discussions |
Jul 14, 2022 12:57 AM

1695 views | 4 replies
How to check if list value exist in folder?

Hi all,I have files that needs to be checked if it is existing in a folder. If it does not exist, a prompt will show which file names are not in my list. Here's a snippet of my code://Sample Data dt = Open( "$SAMPLE_DATA/Quality Control/Diameter.jmp" ); New Column ("Machine Op", Character, Formula ( "Machine_" || :MACHINE || " Op_" || :OPERATOR ) ); dt_list =associati...
UserID16644

Discussions |
Jul 13, 2022 10:07 PM

1374 views | 3 replies

Previous
Next

Latest Discussions

July/August classes from JMP Education

JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for Non-Repairable Systems August 9-12: JMP Pro: Analyzing Curves and Profiles Using the Functional Data Explorer August 16-19: JMP: Statistical Decisions Using ANOVA and Regression August 29-September 1: J...
Di_Michelson

Discussions |
Jul 11, 2022 8:50 AM

663 views | 0 replies
Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

784 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

631 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

777 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

998 views | 0 replies