JMP User Community

Latest Discussions

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

1789 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

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

1276 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

1039 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

4042 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

2652 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

2799 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

1794 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

662 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

783 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

775 views | 0 replies