JMP User Community

Latest Discussions

Column Name as Variable (Very Simple)

Dear All, I am struggling with a very simple problem. I need to select a column name using a variable. Please see below: List = {"A","B","C"}; For( i=1, i<=nitems(List), i++, Add Columns from Update Table( :Name(List[i]) ) ); However, JMP does not accept anything inside ":Name()" that isn't an explicit quoted string.. In fact, "List[i]" is a quoted string, but the code doesn't even run. H...
Valerio

Discussions |
Jul 15, 2022 9:22 AM

1878 views | 6 replies
Multiple Values in a heat map?

I have a heat map that is based off of 2 variables and it's displaying count of materials. Is there a way that I can also include the 4 numeric values that I have in the column selector to also populate in those boxes? So I want the map to still be based on count, but I want the other numeric values in those blocks we all.
Phil_Nash

Discussions |
Jul 15, 2022 8:25 AM

1031 views | 1 replies
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

14821 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

1088 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

1050 views | 3 replies

Previous
Next

Latest Discussions

Multiple Values in a heat map?

I have a heat map that is based off of 2 variables and it's displaying count of materials. Is there a way that I can also include the 4 numeric values that I have in the column selector to also populate in those boxes? So I want the map to still be based on count, but I want the other numeric values in those blocks we all.
Phil_Nash

Discussions |
Jul 15, 2022 8:25 AM

1031 views | 1 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

889 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

5681 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

841 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

1132 views | 4 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

481 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

616 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

482 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

624 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

779 views | 0 replies