Welcome to the JMP User Community!

Latest Discussions

• how to loop through by variable while plotting variable plots

  Hi,I am trying to plot multiple variable charts where Y axis is different columns containing MIP in the column name.I have a column called step name and I need these plots for different step names.Eg: MIP1 for stepA and stepB and so on.I can use "By" variable while creating the plots.But how do I extend this to multiple steps.  dt = Open( "C:\REPORT.csv" ); a = "MIP_"; col = dt << get column names...

  ENTHU

  Discussions |

  Sep 23, 2019 9:32 PM

  2917 views | 3 replies

• 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

  4217 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

  3598 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

  3185 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