I could find two ways for this: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" ); i = 2; Eval(Parse(EvalInsert("dt << Go to(^i^)"))); From p. 431 of jmp scripting guide I adapted the example to this: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" ); i = 2; eval(eval expr(dt << Go to(Expr(i)))); Sometimes JMP doesn't evaluate the arguments of functions. I'm not really sure when this happens and why but it always confuses me. ... View more

Maybe something like this you have in mind? Clear Log(); flatten = function({item_list}, {Default Local},     result = {};     if(N Items(item_list) > 0,         for(i = 1, i <= N Items(item_list), i++,             subitem = item_list;             if(!Is List(subitem),                 insert into(result, subitem),                 t = recurse(subitem);                                insert into(result, t);             );                                    );     );     result; ); callback = function({},     b = Eval List({Z1 << get selected, Z2 << get selected,         Z3 << get selected, Z4 << get selected});     items = flatten(b);     if(N Items(items) > 1,         sql = "SELECT $VARS FROM TABLE";         x = concat items(items, ", ");         sql = munger(sql, 1, "$VARS", x);         show(sql);            ); ); w = New Window("Choose Columns",     V List Box(                H List Box(             Panel Box("Z1",                 Z1 = Check Box({"Z1a", "Z1b", "Z1c", "Z1d", "Z1e", "Z1f"})             ),             Spacer Box(<< Size(30, 0)),             Panel Box("Z2",                 Z2 = Check Box({"Z2a", "Z2b", "Z2c", "Z2d", "Z2e", "Z2f"})             ),             Spacer Box(<< Size(30, 0)),             Panel Box("Z3",                 Z3 = Check Box({"Z3a", "Z3b", "Z3c", "Z3d", "Z3e", "Z3f"})             ),             Spacer Box(<< Size(30, 0)),             Panel Box("Z4",                 Z4 = Check Box({"Z4a", "Z4b", "Z4c", "Z4d", "Z4e", "Z4f"})             )                        ),         Spacer Box(<< Size(0, 20)),         Button Box("Print selected", callback);        ) ); ... View more

I don't have much experience with those but Minimize and Maximize can be used. This example is from the Scripting Guide page 437-438: Least Squares Example The following example uses Minimize to find the least squares estimates of this exponential model, with data taken from the Nonlinear Example/US Population.jmp sample data table. xx = [1790, 1800, 1810, 1820, 1830, 1840, 1850, 1860, 1870, 1880, 1890, 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980, 1990]; yy = [3.929, 5.308, 7.239, 9.638, 12.866, 17.069, 23.191, 31.443, 39.818, 50.155, 62.947, 75.994, 91.972, 105.71, 122.775, 131.669, 151.325, 179.323, 203.211, 226.5, 248.7]; b0 = 3.9; b1 = .022; sseExpr = Expr( Sum( (yy - (b0 * Exp( b1 * (xx - 1790) ))) ^ 2 ) ); sse = Minimize( sseExpr, {b0, b1}, <<tolerance( .00001 ) ); Show( b0, b1, sse ); ... View more

Thanks MS, this makes clear what is going on. It guess there is no way to specify AM/PM format as the "format" parameter in Parse Date (like %p with strptime in C)? ... View more

I think my locale the issue, it is set to 24 hour format (13:00) which makes parsing of AM/PM dates not possible... Show(Informat("11/9/2012 8:58:19 AM", "m/d/y h:m:s")); Show(Informat("11/9/2012 8:58:19", "m/d/y h:m:s")); Results in:   Informat("11/9/2012 8:58:19 AM", "m/d/y h:m:s") = .; Informat("11/9/2012 8:58:19", "m/d/y h:m:s") = 09Nov2012:08:58:19; It seems there is no way to specify AM/PM in the date format. For now I can do this ugly hack... f = function({datetimestring},     size = length(datetimestring);     t = left(datetimestring, size - 3);     d = Parse Date(t, "d/m/y h:m:s");     If(Right(datetimestring, 2) == "PM", Date Increment(d, "Hour", 12, "actual"), d) ); show(f("11/9/2012 8:58:19 AM")); show(f("11/9/2012 8:58:19 PM")); 11Sep2012:08:58:19; 11Sep2012:20:58:19; ... View more

I'm  indeed outside US, but I don't understand why that would effect parsing of dates in this way. With informat ( a , "d/m/y h:m:s" ); the results are the same (I think that informat and parse date are equivalent?) a = "11/9/2012 8:58:19 AM"; b = .; c = .; My JMP Pro version is 9.0.3 ... View more