JMP User Community

Latest Discussions

How to add repeating character values to column?

Hi,

I'm looking to create a column and populate it with a list of character and numeric values - [ Min, Max, 0.5, 0.6,.....,1], and this list repeated 50 times. I usually copy paste these into a column (as shown below), but I'm wondering if there's a way do it using JSL ( using JMP14). Thanks.
D_T_M

Discussions |
Jul 28, 2022 4:00 AM

1028 views | 1 replies
Choose Which Excel Sheet to Open

I have a spreadsheet with several sheets and want to create a script that will read the names of all the sheets and create a modal window letting the user choose which sheet to open then output the name of the chosen sheet as a string.
Jemster

Discussions |
Jul 28, 2022 3:18 AM

1277 views | 1 replies
Need help to recode a column with lab values

Hi In my table I have 3 columns : time, lab data and one temperature.For the lab data I would like to keep only the value when it comes available and set all consecutive rows as null until we have a new lab result.How should I write a script to handle this ? Thanks
LogitTurtle576

Discussions |
Jul 28, 2022 12:38 AM

1372 views | 4 replies
How to set values for columns when adding rows?

Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Add Rows( 1, At End, {:name},{"Freddy"});Hi, I'm trying to add rows, and then set values for each column in the data table but it only adds a row without any values. What am I doing wrong in my script?
PowerOx327

Discussions |
Jul 27, 2022 11:31 PM

1044 views | 1 replies
JMP Multiple Series Stack memory Issue

Hi, I was trying to do Multiple series stack for data set (3.5M rows & 225 Columns). It's giving RAM overflow issue (Out of Memory). Using 32 GB RAM. Is there any way to do this in serial way to avoid the memory issue and get the expected data table?
EdgeFrog719

Discussions |
Jul 27, 2022 7:50 PM

1010 views | 1 replies

Previous
Next

Latest Discussions

Random data generation with given mean and 95% CI

Hi All, 1. Can we generate random data from given Mean & 95% confidence range?. Like I need to generate 100 data with give mean (50) and 95% confidence interval (45-56). 2. In other way, with mean and standard deviation data can be generated but can standard deviation be calculated from 95% CI range? Regards,Yogeshl
Yogeshl

Discussions |
Jul 27, 2022 11:54 AM

4045 views | 5 replies
How do I save (overwrite) a JMP file to Excel and maintaing the Excel file formatting from te orignal Excel File?

I have a piece of JMP script that saves a JMP file to Excel. The Excel file is overwritten with the new data. CTZ = CT_1 << Summary( Group( :Rcd No., :Prog, :Pri, :No., :Matl_Desc, :Issue, :Cog Eng., :Status, :Assign Date, :ECD, :Actionee ) ); CTZ << delete columns( "N Rows" ); CTZ << save( "Daily Rpt Listing.xlsx" ); When the file is save the formatting of the E...
dfusco923

Discussions |
Jul 27, 2022 9:56 AM

2655 views | 4 replies
Multi-process DoE

Hello,I am hoping to get some advice on designing an experiment. I have a process that has 4 steps sequentially. Step A comes first, then step B, then C and finally D. Response is measured at the completion of step 4. Each step has two factors, each with two levels.I need to model the response as a function of all the 8 factors, taking into account all two-way interactions. I like to make sure no ...
MarkovVaribles1

Discussions |
Jul 26, 2022 7:48 AM

1444 views | 3 replies
Adjusting y axis labels when plotting box-cox transformed data

JMP® Pro 16.2.0When plotting box-cox transformed data - how can the y axis value label be set to show the original scale? In log transfomation one can simply select a linear scale and the actual value scale is shown but with log spacings. There does not seem to be any simple way of doing this in y-axis settings. JMP® Pro 16.2.0
Grumpybaldprof

Discussions |
Jul 26, 2022 3:14 AM

2801 views | 5 replies
Table Box with multiline cells

Just noticed slight problem (one more to the long list of problems) with Table Box. I'm trying to add fairly long string to Table Box and because Table Box doesn't really support multiple lines I tried using Col Box with Table Box(<< Set Wrap())... issue with this is that it seems to break everything else Names Default To Here(1); tb = Table Box( nceb = Number Col Edit Box("Order", []), scb1 =...
jthi

Discussions |
Jul 23, 2022 5:13 AM

1796 views | 4 replies

Previous
Next

Latest Discussions

Choice model platform and marginal effects?

Hi everyone,I have used the choice model platform to design and analyse choice experiments. However, at the analysis step, there are some parts of JMP platform output that are not clear, and I wonder if you can provide an answer:It is not clear how marginal effects are calculated in JMP.More specifically, how do we obtain marginal probabilities from marginal utilities since neither the utility fun...
gav2013

Discussions |
Jul 18, 2022 7:14 AM

1011 views | 0 replies
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