Welcome to the JMP User Community!

Latest Discussions

• Set Current Directory

  Hi.  I have written some sentences to set the current directory where to find the files of interest but it dones not work. Any help? Thanks     Set Current Directory( "/Users/manel/Desktop/Municipales_Spain" ); my_file = Pick File( {"All files|*"} ); dt = Open( my_file ); dt << Select Where( Código de Provincia == 44 ); SubDt = dt << Subset( output table name( "Matarranya1" ) ); Close( "Mata...

  gallardet

  Discussions |

  Jul 10, 2019 1:10 PM

  8993 views | 5 replies

• How to group multiple data transformations into one script

  Hello, I'm kind of new to scripting, and I was wondering if anyone can help me with finding resources to learn about how to put this process into one script. Here is an outline of the work that I have done. 1.  Use tabulate to create summaries from an original table2.  Save tabulate as data table (the result is 3 separate tables)3.  For each of the 3 tables     a.  Add a new column with a formula ...

  JeffSwartzel

  Discussions |

  Jul 10, 2019 12:36 PM

  2949 views | 2 replies

• Add a new window for Start & End Calendar date selection box/ date entry box

  Hi JMP community, I usually use jmp preselected and plot graphs need a help to add selection date amend for my script below.   As per below, once I call out database, I have to amend the dates for start & end in order to query needed data on input dates.   dt = Open Database( "DSN=xxx ;Description=yyy;UID=zzz;PWD=zzz;APP=JMP;DATABASE=MATS;", "SELECT pen_parametric.pn_id, pen_parametric.equiplk_k...

  OtisZeca

  Discussions |

  Jul 10, 2019 12:02 PM

  6019 views | 4 replies

• Nominal variable in ANOVA report

  I have 28 music clips. 14 of them are composed in major mode and rest 14 in minor mode. I am looking at emotional response for the music and preference for the music against the mode of the music.  I have two questions: 1) Should Mode (Major and Minor) be put as nominal variable or ordinal variable? 2) When I put Mode as a nominal variable with value labels - Major = 0, Minor = 0, and then fit the...

  2605

  Discussions |

  Jul 10, 2019 6:48 AM

  8145 views | 4 replies

• Opening Running Queries from script

  I'm trying to create UI where sql query can be run on foreground when user presses a button and this button may be pressed multiple times. I would like to the user how many queries are currently running. If possible I would like to use Running Queries which can be found from View menu. Can this be opened directly from script?

  jthi

  Discussions |

  Jul 9, 2019 10:53 PM

  5216 views | 4 replies