219338_zh-CN

liliconcom

JMP14 脚本与旧版本的兼容性

你好呀，

 

我正在寻找是否有人可以就编写脚本并使其与旧版本的 JMP 兼容提供一些建议。 最近，我一直在编写一个脚本，该脚本将 cvs 文件转换为 JMP 上的数据表，并将不同的列设置为具有不同的属性（例如建模类型、公式等）。然而，它在使用 JMP14 的 PC 上运行良好当我的一位同事尝试使用该脚本时，它不起作用。 我发现他正在使用 JMP13，并且当脚本运行时，它不会将建模类型更改为“标称”，而是“连续”。

 

请参阅我用于建模转换的脚本摘录。

....
New Column( "DateTime",
   Numeric,
   "Nominal",
   Format( "y/m/d h:m"),
   Input Format( "y/m/d h:m:s", 3 )
  ),
....

 

如果有办法使脚本兼容，我希望有人可以提供一些建议。 任何帮助将非常感激。

 

谢谢，

卢克

回复：JMP14 脚本与旧版本的兼容性

你好@Jeff_Perkinson ，我尝试了你最近发送的两种方法。

 

第一种方法似乎只适用于我的 JMP14 而不是 13，但是第二种方法（此消息是直接回复的方法）适用于两个版本！

 

 

回复：JMP14 脚本与旧版本的兼容性

我的错。 我没有完全编辑以前的版本。 这个有没有用：

 

jmpver = Num( Left( JMP Version(), 2 ) );
path = Get Default Directory(); 
f = Pick File( "Select .csv file with  data", path, {"Excel|csv;xlsx;xls", "JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, "" ); 

dt = Open( f );

If(
 jmp ver > 13, 
 // use string argument
 dt
  << New Column( "DateTime", Numeric, "Continuous", Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s") )
  << New Column( "NSR_ID", Character, "Nominal" )
  << New Column( "TaskId", Character, "Nominal" );
  // etc.
, 
 // use named argument
 dt
  << New Column( "DateTime", Numeric, Continuous, Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s") )
  << New Column( "NSR_ID", Character, Nominal )
  << New Column( "TaskId", Character, Nominal );
  // etc.
);

回复：JMP14 脚本与旧版本的兼容性

另一个想法，在这一点上，这只是一个智力练习，以弄清楚为什么两者的行为不同。 如果你想确保约会时间列是标称的，您可以在 Open() 之后执行此操作，并且应该可以。

 

newdt = Open(
 "$SAMPLE_DATA/../Import Data/BigClass.txt",
 columns(
  New Column( "Name", Character, "Nominal" ),
  New Column( "Date",
   Numeric,
   "Continuous",
   Format( "m/d/y", 10 ),
  ),
  New Column( "Sex", Character, "Nominal" ),
  New Column( "height", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "weight", Numeric, "Continuous", Format( "Best", 12 ) )
 ),
 Import Settings(
  End Of Line( CRLF, CR, LF ),
  End Of Field( Tab, CSV( 0 ) ),
  Strip Quotes( 1 ),
  Use Apostrophe as Quotation Mark( 0 ),
  Use Regional Settings( 0 ),
  Scan Whole File( 1 ),
  Treat empty columns as numeric( 0 ),
  CompressNumericColumns( 0 ),
  CompressCharacterColumns( 0 ),
  CompressAllowListCheck( 0 ),
  Labels( 0 ),
  Column Names Start( 1 ),
  Data Starts( 1 ),
  Lines To Read( "All" ),
  Year Rule( "20xx" )
 )
);
<BR />//set modeling type after import
newdt:Date << set modeling type( "Nominal" );

回复：JMP14 脚本与旧版本的兼容性

这是在 JMP 14 和 JMP 13 中运行的另一个测试。 它适用于我：

 

Open(
 "$SAMPLE_DATA/../Import Data/BigClass.txt",
 columns(
  New Column( "Name", Character, "Nominal" ),
  New Column( "Date",
   Numeric,
   "Nominal",
   Format( "m/d/y", 10 ),
  ),
  New Column( "Sex", Character, "Nominal" ),
  New Column( "height", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "weight", Numeric, "Continuous", Format( "Best", 12 ) )
 ),
 Import Settings(
  End Of Line( CRLF, CR, LF ),
  End Of Field( Tab, CSV( 0 ) ),
  Strip Quotes( 1 ),
  Use Apostrophe as Quotation Mark( 0 ),
  Use Regional Settings( 0 ),
  Scan Whole File( 1 ),
  Treat empty columns as numeric( 0 ),
  CompressNumericColumns( 0 ),
  CompressCharacterColumns( 0 ),
  CompressAllowListCheck( 0 ),
  Labels( 0 ),
  Column Names Start( 1 ),
  Data Starts( 1 ),
  Lines To Read( "All" ),
  Year Rule( "20xx" )
 )
);

注意：该列将填充缺失值，因为它不是日期值。 没关系，因为这不是我们要测试的。 我们只需要将列设为 Nominal 建模类型。

回复：JMP14 脚本与旧版本的兼容性

由此看来，添加更多列似乎是我的问题所在，因为我的原始方法使用 JMP13 中的以下脚本工作。

 

Open(dt,
columns(
  New Column( "DateTime",
   Numeric,
   "Nominal",
   Format( "y/m/d h:m"),
   Input Format( "y/m/d h:m:s", 3 )
  );
  
  
  
 );
 
);

回复：JMP14 脚本与旧版本的兼容性

你好@Jeff_Perkinson使用我的原始代码，这似乎与您的相似。

 

path = Get Default Directory(); 
dt = Pick File("Select .csv file with  data", path, {"Excel|csv;xlsx;xls", "JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, ""); 
Open(dt,
columns(
  New Column( "DateTime",
   Numeric,
   "Nominal",
   Format( "y/m/d h:m"),
   Input Format( "y/m/d h:m:s", 3 )
  ),
  New Column( "NSR_ID", Character, "Nominal" ),
  New Column( "TaskId", Character, "Nominal" ),
  New Column( "TaskType", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "TaskCreateTime",
   Numeric,
   "Continuous",
   Format( "y/m/d h:m:s", 26, 3 ),
   Input Format( "y/m/d h:m:s", 3 )
  ),
  New Column( "RecipeFile", Character, "Nominal" ),
  New Column( "PureRecipeFile", Character, "Nominal" ),
  New Column( "Product", Character, "Nominal" ),
  New Column( "Layer", Character, "Nominal" ),
  New Column( "LotLabel", Character, "Nominal" ),
  New Column( "PureLotLabel", Character, "Nominal" ),
  New Column( "Reticle1", Character, "Nominal" ),
  New Column( "IllumId", Character, "Nominal" ),
  New Column( "ResultFile", Character, "Nominal" ),
  New Column( "ExpLogName", Character, "Nominal" ),
  New Column( "AtmPres", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "AtmPresTime",
   Numeric,
   "Continuous",
   Format( "y/m/d h:m:s", 26, 3 ),
   Input Format( "y/m/d h:m:s", 3 )
  ),
  New Column( "WCt", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "RepCt", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "AFZType", Character( 1 ), "Nominal" ),
  New Column( "MeasPos/X", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "MeasPos/Y", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "MeasPos/Rot", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "MeasPos/Z", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "MeasPos/TiltX", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "MeasPos/TiltY", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "MeasMode", Character( 1 ), "Nominal" ),
  New Column( "ScanVelocity", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "ScanLength", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "ScanDirection", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "ScanNum", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "MeasAveTime", Character( 1 ), "Nominal" ),
  New Column( "AsocPk", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "RefMeasDate", Character, "Nominal" ),
  New Column( "WTD_Z", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "IF_Roll(ZF1)", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "IF_Pitch(ZF12)", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "IF_AF-Z(Ave_ZF12)",
   Numeric,
   "Continuous",
   Format( "Best", 12 )
  ),
  New Column( "IF_AIS-Z(ZB3)", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "IF_AIS-Z(ZB3_Abbe)",
   Numeric,
   "Continuous",
   Format( "Best", 12 )
  ),
  New Column( "IF_ZF1", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "IF_ZF2", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "IF_ZF12", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "IF_ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Roll_ZF1", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Roll_ZF2", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Roll_ZF12", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Roll_ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Pitch_ZF12", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Pitch_ZF1ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Pitch_ZF2ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "RetryCount", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "WaterRefInterp", Character, "Nominal" ),
  New Column( "OK/NG", Character, "Nominal" ),
  New Column( "G-ASOC_AFZ", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "WFMsens_Ave", Character( 1 ), "Nominal" ),
  New Column( "Ave", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "TiltX", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "TiltY", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "CurveX", Character( 1 ), "Nominal" ),
  New Column( "1", Character( 1 ), "Nominal" ),
  New Column( "2", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "3", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "4", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "5", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "6", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "7", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "8", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "9", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "10", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "11", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "12", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "13", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "14", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "15", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "16", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "17", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "18", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "19", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "20", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "21", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "22", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "23", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "24", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "25", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "26", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "27", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "28", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "29", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "30", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "31", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "32", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "33", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "34", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "35", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "36", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "37", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "38", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "39", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "40", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "41", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "42", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "43", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "44", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "45", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "46", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "47", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "48", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "49", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "50", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "51", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "52", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "53", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "54", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "55", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "56", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "57", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "58", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "59", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "60", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "61", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "62", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "63", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "64", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "65", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "66", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "67", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "68", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "69", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "70", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "71", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "72", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "73", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "74", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "75", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "76", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "77", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "78", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "79", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "80", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "81", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "82", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "83", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "AtmPres 2", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "AtmPresTime 2",
   Numeric,
   "Continuous",
   Format( "y/m/d h:m:s", 26, 3 ),
   Input Format( "y/m/d h:m:s", 3 )
  ),
  New Column( "AtmPresTimeDelta",
   Numeric,
   "Continuous",
   Format( "Best", 12 )
  ),
  New Column( "AtmPresEventID", Character, "Nominal" )
 ),
 Import Settings(
  End Of Line( CRLF, CR, LF ),
  End Of Field( Comma, CSV( 1 ) ),
  Strip Quotes( 0 ),
  Use Apostrophe as Quotation Mark( 0 ),
  Use Regional Settings( 0 ),
  Scan Whole File( 1 ),
  Treat empty columns as numeric( 0 ),
  CompressNumericColumns( 0 ),
  CompressCharacterColumns( 0 ),
  CompressAllowListCheck( 0 ),
  Labels( 1 ),
  Column Names Start( 1 ),
  Data Starts( 2 ),
  Lines To Read( "All" ),
  Year Rule( "20xx" )
 )
);

这可以使 JMP14 中的 DateTime“标称”建模类型，但不是 13。

 

当使用您的简化脚本时，它会创建正确类型的模型。

 

谢谢您的帮助

回复：JMP14 脚本与旧版本的兼容性

所有应有的尊重@Mark_Bailey ，但我认为问题不在于指定建模类型的参数样式。

 

我尝试了原始代码：

 

dt = New Table();

dt << New Column( "DateTime",
 Numeric,
 "Nominal",
 Format( "y/m/d h:m" ),
 Input Format( "y/m/d h:m:s", 3 )
);

在 JMP 12、JMP 13 和 JMP 14 中，并在每种情况下都得到一个标称列。

 

我认为一定有其他事情发生。

 

@LukeFarrell ，您能否尝试上面的简化代码，看看它是否会在您的 JMP 14 机器和 JMP 13 的同事机器上创建一个 Nominal 列？

 

如果确实如此，那么您的（大概）较大的脚本中还有其他东西在干扰。 如果是这种情况，我们将需要有关更大脚本的更多详细信息来帮助您。

回复：JMP14 脚本与旧版本的兼容性

再次感谢您的所有帮助，但我仍然遇到同样的问题。 所以目前如果我使用 JMP14 或 13，DateTime 列仍然是连续的。

 

我不确定为什么会这样，因为我复制了您使用的方法，如下所示：

 

jmpver = Num( Left( JMP Version(), 2 ) );
path = Get Default Directory(); 
f = Pick File( "Select .csv file with  data", path, {"Excel|csv;xlsx;xls", "JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, "" ); 

dt = Open( f );

If(
 jmp ver > 13, 
 // use string argument
 dt <<  New Column( "DateTime", Numeric, "Nominal", Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s") );
 dt <<  New Column( "NSR_ID", Character, "Nominal" );
 dt << New Column( "TaskId", Character, "Nominal" );
\\\etc.

, 
 
 // use named argument
 dt << New Column( "DateTime", Numeric, Nominal, Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s" ) );
 dt <<  New Column( "NSR_ID", Character, "Nominal" );
 dt << New Column( "TaskId", Character, "Nominal" );
\\\etc.
);

 

回复：JMP14 脚本与旧版本的兼容性

你有正确的想法，但语法是错误的。 在不深入细节的情况下，您使用逗号分隔函数参数。 您将函数调用与分号粘合在一起。 所以 If() 函数调用应该用逗号分隔参数（布尔值、表达式、布尔值、表达式...）。 表达式可能涉及多个函数，因此在一个参数中，我们用分号将函数粘合在一起。 它可能看起来像这样：

 

jmpver = Num( Left( JMP Version(), 2 ) );

path = Get Default Directory();

f = Pick File( "Select .csv file with  data", path, {"Excel|csv;xlsx;xls", "JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, "" ); 

dt = Open( path || f );

If(
 jmp ver > 13, 
 // use string argument
 dt << New Column( "Date Time", Numeric, "Nominal", Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s", 3 ) );
 dt << New Column( "Blah", Numeric, "Nominal", Values( ... ) );
 dt << New Column( "Blah Blah", Numeric, "Nominal", Values( ... ) );
 , 
 // use named argument
 dt << New Column( "Date Time", Numeric, Nominal, Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s", 3 ) );
 dt << New Column( "Blah", Numeric, Nominal, Values( ... ) );
 dt << New Column( "Blah Blah", Numeric, Nominal, Values( ... ) );
);

（请注意，我在 If() 函数中留下了第一个逗号以强调其用途。）

 

第一个表达式将三个 Send() 函数粘合在一起。 每条消息发送都会添加一个新列。

 

我希望这些信息具有启发性而不是令人困惑！ JSL 有点不同的.

 

回复：JMP14 脚本与旧版本的兼容性

嗨，马克，

再次感谢您的帮助。 然后，由于我有更多列，我应该将它们同时放入字符串参数和如下所示的名称中吗？

 

If(
 jmp ver > 13, 
 // use string argument
 dt << New Column( "DateTime", Numeric, "Nominal", Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s", 3 ) ),<BR />
        dt << New Column( "NSR_ID", Character, "Nominal" ),
\\and follows for the rest
  
 // use named argument
 dt << New Column( "DateTime", Numeric, Nominal, Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s", 3 ) ),

        dt << New Column( "NSR_ID", Character, "Nominal" ),
\\and follows for the rest
);

或者我可以像以前那样做类似的方法吗？

 

再次感谢，

卢克

回复：JMP14 脚本与旧版本的兼容性

我在想这样简单的事情：

 

jmpver = Num( Left( JMP Version(), 2 ) );

path = Get Default Directory();

f = Pick File( "Select .csv file with  data", path, {"Excel|csv;xlsx;xls", "JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, "" ); 

dt = Open( path || f );

If(
 jmp ver > 13, 
 // use string argument
 dt << New Column( "DateTime", Numeric, "Nominal", Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s", 3 ) ), 
 // use named argument
 dt << New Column( "DateTime", Numeric, Nominal, Format( "y/m/d h:m" ), Input Format( "y/m/d h:m:s", 3 ) ),
);

回复：JMP14 脚本与旧版本的兼容性

嗨，马克，

 

由于我对 JMP 比较陌生，我不确定如何执行此操作。

 

这是可以使用的方法吗？

 

jmpver = num(left(jmpversion(),2));
path = Get Default Directory(); 
dt = Pick File("Select .csv file with  data", path, {"Excel|csv;xlsx;xls", "JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, ""); 
Open(dt,
columns(
  New Column( "DateTime",
   Numeric,
   if(jmpver >= 14,
    "Nominal",
    /*else if*/ jmpver == 13,
    Nominal),
   Format( "y/m/d h:m"),
   Input Format( "y/m/d h:m:s", 3 )
  ),

.....

谢谢您的帮助，

卢克

回复：JMP14 脚本与旧版本的兼容性

不幸的是，我们必须改变一些参数作为参数传递的方式。 在您的情况下，指定数据列的建模类型的新的和首选的方法是“连续的” （一个字符串）。 此前，它是一个连续的（命名参数）。

 

好消息是您可以向 JMP 询问其版本信息并使用如果（）函数来确定进行的最佳方式。