JMP User Community

Latest Discussions

How do I manipulate column formulae in data tables by scripting?

Hi, I'm trying to add a formula to convert values in a selected column through scripting without having to add any new columns in the data table, is there a way to edit formulas for a column by scripting? For example I'm trying to set the height column in this data table to be halved when I run the script:Names Default To Here( 1 ); Open( "$SAMPLE_DATA/Big Class.jmp" ); Current Data Table() << Ge...
PowerOx327

Discussions |
Jul 28, 2022 6:29 AM

1253 views | 2 replies
Append calendar box

Hi, I am trying to create a UI to select dates. I have added a button box which will append calendar box to the panel box but every time I click, it will keep adding elements to the panel box. I want to hide the calendar box on second click. Is there a way to achieve this? Here's my code:sd=Today(); ed=Today(); New Window( "Query Date", <<Modal, HListBox( Panel1= PanelBox( "From Time"), Bu...
Jackie_

Discussions |
Jul 28, 2022 6:00 AM

1285 views | 2 replies
How do I use the include function to run a separate script which uses an open data table?

Hi all, I've created a script which pulls from SQL and creates a data table as so: Names Default To Here( 1 ); dtFROMSQL = Execute SQL( databaseConnectionHandle, "SELECT HEIGHT, WEIGHT FROM Bigclass", "NewTable" ); Include(filepathforsecondscript.jsl);And then I have another script in my personal folder which adds a column to the data table:Current Data Table( dtFROMSQL ); dt << New Column( "X",...
PowerOx327

Discussions |
Jul 28, 2022 5:45 AM

1794 views | 3 replies
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

1031 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

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

4047 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

2656 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

2805 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

1797 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

778 views | 0 replies