Welcome to the JMP User Community!

Latest Discussions

• Eval insert SQL

  Hi All, i am trying to produce an SQL statment that will bring only rows with matching id names. i have a userlist that i want to Eval insert into the SQL string. problem is that it parses it with double quotes instead of single quotes.       Names default to here (1);
// got the userlist from a data table using dt:users << get as matrix
userlist = {"01E1B5C0651EDA80", "F62B70921920FCBE", "909D3502...

  ron_horne

  Discussions |

  Dec 25, 2022 1:45 PM

  4588 views | 9 replies

• pulling information with date condition: put filename into list if it is greater than a specified date and time

  Hi,I m trying to  get the list of files name in a directory with given condition if it is 1) zip archive and also the 2) creation date greater than yyyy/mm/dd. Below is my script. My question1) it ran without error but not return empty list. I 'm not sure what is the issue (perhaps the date).
  2) how can I set the creation date () output format to yyyy/mm/dd hh:mm:ss? 3) it take long time to loop th...

  dadawasozo

  Discussions |

  Dec 24, 2022 2:10 PM

  2675 views | 3 replies

• JSL - Repeats within a platform function

  Names Default To Here( 1 ); // Create an Example data table dt = currentdatatable(); // Get the names of the columns in the data table colNames = dt << get column group( "WLS" ); nIters = 2; Neural( Y( :Type ), X(eval(colNames)), Validation Method( "KFold", 5 ), Set Random Seed( 2 ), for( k=1, k <= nIters, k++, Fit( NTanH ( 2 ) ) ), ); I am trying to fit more than 1 neural model using at...

  Joost

  Discussions |

  Dec 24, 2022 3:28 AM

  3055 views | 5 replies

• Why are my fit models showing different factor significance? In "model 1", Random Block is a Random Effect rather than a Fixed Effect, whereas "model 2" lists all the factors as Fixed Effects.

  When I clicked Fit Model, "model 1" popped up, including "Random Block & Random" as a factor, which means "Random Block" is a Random rather than Fixed Effect. However, When I run "model 2" with just "Random Block" as a factor, everything becomes less efficient. Which is more correct and why? Also, I'm used to the Model 2 output, in which I can click on Scaled Estimates. And I was taught at a JMP t...

  evtran

  Discussions |

  Dec 23, 2022 8:45 PM

  2403 views | 3 replies

• Automate odds ratio to populate a table

  Hi all! Is there an easy way to automate a table like the following for a large data set? Essentially I'm reporting my data in the following way with number and percentage in each group and the odds ratio with the confidence interval:  Total n (%)Survived n (%)Died n (%)OR (CI)Femalex (x%)x (x%)x (x%)x.xx (x.xx-x.xx)Heart diseasex (x%)x (x%)x (x%)x.xx (x.xx-x.xx) I've been doing my analysis using ...

  lily1287

  Discussions |

  Dec 23, 2022 1:39 PM

  2904 views | 2 replies