Welcome to the JMP User Community!

Latest Discussions

• Iterate through rows and select matching rows script then average

  Hello,  I am trying to write a script that uses one column to select matching cells there and then use those selected rows to find the average of the numbers in the column next to it but am not quite sure how to do that. Here is an example table of what I am working on (the last average cloumn is what I need a script to do):Matching Column:Numbers:Average of grouped numbersa23a43b24b44b64c36c66c96...

  KdeWitt

  Discussions |

  Sep 24, 2019 7:25 AM

  4312 views | 3 replies

• CV, GCV & smoothing parameter (alpha) in p-spline?

  Hi everyoneplease; how to calculate CV, GCV & smoothing parameter (alpha)in penalized spline regression? regards; 

  Raaed

  Discussions |

  Sep 24, 2019 4:35 AM

  4433 views | 4 replies

• 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

  3125 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

  4535 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

  3835 views | 2 replies