Welcome to the JMP User Community!

Latest Discussions

• What is the difference between Open Database() and New SQL Query() when accessing databases?

  Hi, I am trying to pull down a view from an Oracle database.  The Data Base Name is ACTPROD.WORLD, Schema is ABASE, and Table is RPT_H25_3MONTHS_VIEW Using Database -> Open Table, JMP created the following script:Open Database( "DSN=ACTPROD.WORLD;UID=;PWD=;DBQ=ACTPROD.WORLD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=...

  BrianG

  Discussions |

  Sep 23, 2019 12:15 PM

  4213 views | 4 replies

• Add prefix to column names (scripting)

  Hi   I have a a JMP dataset and want to a add the same prefix to all the column names in that dataset, my code below doesn't do quite what I want. dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt2 = dt << For( i = 25, i <= N Cols( dt ), i++, cName = Column( dt, i ) << Get Name; newname = cName || "Prefix_"; Column( dt, i ) << Set Name( newname ); );   Now, a second scenario: Imagine the column "se...

  Newbie2Jumpie

  Discussions |

  Sep 23, 2019 5:47 AM

  3597 views | 2 replies

• JOURNAL Report Title

  I want to create a journal 1st page with title that put in the centre of the page. But, seem like the textbox is always show up at the top of the page. Any idea?      nw = New Window( "Reports", <<Journal, hlb = H List Box( lub = Lineup Box( N Col( 1 ), //ob_stat = Outline Box( "Statistic Summary"), tb = Text Box( "Pegasus Characterization Report" ), Page Break Box(), // start new page ...

  OneNorthJMP

  Discussions |

  Sep 22, 2019 8:27 PM

  3184 views | 2 replies

• DOE: All out custom design or augment design after DSD?

  I have 7 continuous factors and 2 discrete numeric factors (presence/absence). I would like to use DOE to identify which factors play a role in the response, identify if there are any interactions between factors and finally determine the range of factors for optimal response. I can think of two ways to do it and I am not sure which one gives me a more accurate model to identify factors and intera...

  dtsang

  Discussions |

  Sep 22, 2019 4:19 PM

  3476 views | 2 replies

• How to evaluate model accuracy on holdout set

  Hello, I am using JMP 13 and I can not seem to find a way to automaticaly evaluate my model's accuracy on the holdout set. I am buliding a linear regression model.So I would like to preserve the model (with the contained effects and estimates sizes), which was bulit on the training set, but calculate accuracy predictors (R^2, R^2 adjusted and RMSE) on the holdout set. In the moment the only soluti...

  Danijel_V

  Discussions |

  Sep 21, 2019 4:34 AM

  2561 views | 1 replies