410104_zh-CN

liliconcom

设置缺失数据的属性

可以肯定，这对于“知道”的人来说是一个简单的解决方法，但是，我一直在努力弄清楚。 我在做我的限制时有一个 pass_fail 列，需要弄清楚如何将“失败”分配给缺失的数据。我使用同一个表来绘制分布，因此为缺失的数据分配一个随机数可能会导致问题。

 

提前致谢

 

列( dt_split, N Cols( dt_split ) ) << Set Property( "Value Labels", {1 = "Pass", 0 = "Fail", -999 = "Fail" });

 

 colList = dt_split << Get Column Names( numeric, string );
 
 foundCols = "";
 
 i = 2;

 For( i = 1, i <= N Items( colList ), i++, 
 
  Spec = Column( dt_split, colList[i] ) << Get Property( "Spec Limits" );
   
  If( Is Empty( Spec ) == 0, 
   
   dt_split << New Column( (Column( dt_split, colList[i] ) << Get Name) || " Pass_Fail" );
    
   If( Is Missing( Try( Spec["LSL"], . ) ) == 0, 
    
    dt_split << Select Where( As Column( dt_split, colList[i] ) < Spec["LSL"] );
     
    Try( Column( dt_split, N Cols( dt_split ) )[dt_split << get selected rows] = 0 );
   );
    
   If( Is Missing( Try( Spec["USL"], . ) ) == 0, 
    
    dt_split << Select Where( As Column( dt_split, colList[i] ) > Spec["USL"], Current Selection( "Extend" ) );
     
    Try( Column( dt_split, N Cols( dt_split ) )[dt_split << Get Selected Rows] = 0 );
   );
   
   Wait( 0.5 );
    
   dt_split << Invert Row Selection;
    
   Wait( 0.5 );
   
   ColNotes = Eval( test ) || "_" || "PassFail";
   
   Try( Column( dt_split, N Cols( dt_split ) )[dt_split << Get Selected Rows] = 1 );
    
   Column( dt_split, N Cols( dt_split ) ) << Set Property( "Value Labels", {1 = "Pass", 0 = "Fail", -999 = "Fail" } );
   
   Column( dt_split, N Cols( dt_split ) ) << Set Property( "Value Ordering", {1, 0} );
   
   Column( dt_split, N Cols( dt_split ) ) << Set Property( "Description", "PASS_FAIL" );
   
   Column( dt_split, N Cols( dt_split ) ) << Set Property( "Notes", ColNotes );
   
   If( foundCols == "",
    foundCols = ":Name(\!"" || (Column( dt_split, colList[i] ) << Get Name) || " Pass_Fail\!")",
    foundCols = foundCols || ", " || ":Name(\!"" || (Column( dt_split, colList[i] ) << Get Name) || " Pass_Fail\!")"
   );
   
  );
  dt_split << Clear Select;
 );

 

col << Set Property( "Value Labels", {1 = "Pass", 0 = "Fail", 999 = "Fail"});

数据表脚本编写回复：设置缺失数据的属性

如果您尝试对缺失值使用值标签。您应该能够直接在 Set 属性中使用它：

col << Set Property( "Value Labels", {. = "Fail", 1 = "Pass", 0 = "Fail", 999 = "Fail"} );

编辑：

另外，如果那些 999 已经丢失了带有“随机数”的数据？您还可以使用 Missing Value Codes 列属性将它们从分析中隐藏：

 

Set Property("Missing Value Codes", {999})