270312_zh-CN

liliconcom

使用两个时间点创建分类变量

如果有人可以提供帮助，我将不胜感激！

 

我正在尝试创建一个基于两个变量的类别变量，以反映就业变化：JOBCODE TimePoint 2和JOBCODE TimePoint 2。

从本质上讲，此分类变量将使我能够查看从时间点1到时间点2：任何给定的雇员是否发生以下事件之一：加入组织（新雇员），更改JOBCODE（在组织内转移）或离开组织（终止/分离）。    

下面的代码表示我的数据结构是因为任何新员工在时间点1的JOBCODE都将为空白/空值，任何终止的员工在时间点2的JOBCODE都将为空/空值，而任何更换职位的员工都将具有一个空值。从时间点1到时间点2的字段中不匹配的JOBCODE。

就空白/空命令而言，我尝试了许多不同的方法。  我尝试使用isMissing以及==“”，还尝试了！contains。  他们都不工作。  只要使用这些样式中的一种，我就没有偏好。 

对于那些要调动的员工，我只关心他们是否将工作代码保留在我的清单中

我创建了一个模拟数据表。  为了示例，第1列是一些由员工ID组成的。  第2列和第3列代表时间点1和时间点2的作业代码。  第4列是基于在第2列和第3列中输入的值而期望的输出。  第5栏是一些说明，以供澄清。 

 

new column ("JOBCODE Status", Character, Nominal) << Formula

(If (Contains (mylist, :"JOBCODE Timepoint1") & !Contains (mylist, :"JOBCODE Timepoint2"),"Change in JOBCODE",

(If (Contains (mylist, :"JOBCODE Timepoint1") & Contains (mylist, :"JOBCODE Timepoint2"),"No Change",

(If (Contains (mylist, :"JOBCODE Timepoint1") & isMissing (:"JOBCODE Timepoint2"),

"Termination/Separation",

(If (isMissing (mylist, :"JOBCODE Timepoint1") & Contains (:"JOBCODE Timepoint2"),

"New Employee",



))))))));



mylist= {"HH0029",

"HH0030",&nbsp;&nbsp;&nbsp;

"HH0241",

"HH0242",&nbsp;&nbsp;&nbsp;

"HH0317",&nbsp;&nbsp;&nbsp;

"HH0635",&nbsp;&nbsp;&nbsp;

"HH0635",&nbsp;&nbsp;&nbsp;

"HH0636",&nbsp;&nbsp;&nbsp;

"HH0636",&nbsp;&nbsp;&nbsp;

"HH0639",&nbsp;&nbsp;&nbsp;

"HH0742",&nbsp;&nbsp;&nbsp;

"HH0750",&nbsp;&nbsp;&nbsp;

"HX0002",&nbsp;&nbsp;&nbsp;

"HX0003",&nbsp;&nbsp;&nbsp;

"HX0008",&nbsp;&nbsp;&nbsp;

"HX0010",&nbsp;&nbsp;&nbsp;

"HX0022",&nbsp;&nbsp;&nbsp;

"HX0106",&nbsp;&nbsp;&nbsp;

"HX0106",&nbsp;&nbsp;&nbsp;

"HX0107",&nbsp;&nbsp;&nbsp;

"HX0114",&nbsp;&nbsp;&nbsp;

"HX0115",&nbsp;&nbsp;&nbsp;

"SH0049",&nbsp;&nbsp;&nbsp;

"SH0504",&nbsp;&nbsp;&nbsp;

"SH0678",&nbsp;&nbsp;&nbsp;

"HH0113",&nbsp;&nbsp;&nbsp;

"HH0708",&nbsp;&nbsp;&nbsp;

"HH0746",&nbsp;&nbsp;&nbsp;

"HX0111",&nbsp;&nbsp;&nbsp;

"NU0017",&nbsp;&nbsp;&nbsp;

"NU0100",&nbsp;&nbsp;&nbsp;

"NU0200",&nbsp;&nbsp;&nbsp;

"NU0203",&nbsp;&nbsp;&nbsp;

"NU0206",

"NU0207",

"NU0213",

"NU0243",&nbsp;&nbsp;&nbsp;

"NU0244",

"NU0300",&nbsp;&nbsp;&nbsp;

"NU0301",

"NU0305",&nbsp;&nbsp;&nbsp;

"NU0327",&nbsp;&nbsp;&nbsp;

"NU0328",&nbsp;&nbsp;&nbsp;

"NU0362",&nbsp;&nbsp;&nbsp;

"NU0364",&nbsp;&nbsp;&nbsp;

"NU0400",&nbsp;&nbsp;&nbsp;

"NU0422",

"NU0423",

"NU0424",&nbsp;&nbsp;&nbsp;

"NU0425",&nbsp;&nbsp;&nbsp;

"NU0440",&nbsp;&nbsp;&nbsp;

"NU0461",&nbsp;&nbsp;&nbsp;

"NU0615",&nbsp;&nbsp;&nbsp;

"NU0618",&nbsp;&nbsp;&nbsp;

"NU0619",&nbsp;&nbsp;&nbsp;

"NU0620",&nbsp;&nbsp;&nbsp;

"NU0621",&nbsp;&nbsp;&nbsp;

"NU0622",&nbsp;&nbsp;&nbsp;

"NU0625",&nbsp;&nbsp;&nbsp;

"NU0800",&nbsp;&nbsp;&nbsp;

"NU0801",&nbsp;&nbsp;&nbsp;

"NU0923",&nbsp;&nbsp;&nbsp;

"NX0002",&nbsp;&nbsp;&nbsp;

"NX0006",&nbsp;&nbsp;&nbsp;

"NX0017",&nbsp;&nbsp;&nbsp;

"NX0018",&nbsp;&nbsp;&nbsp;

"NX0019",&nbsp;&nbsp;&nbsp;

"NX0023",&nbsp;&nbsp;&nbsp;

"NX0125",&nbsp;&nbsp;&nbsp;

"NX0465",

"NX0466",&nbsp;&nbsp;&nbsp;

"NX0609",&nbsp;&nbsp;&nbsp;

"NX0610",&nbsp;&nbsp;&nbsp;

"NU0610",&nbsp;&nbsp;&nbsp;

"NU0700",&nbsp;&nbsp;&nbsp;

"NU0710",&nbsp;&nbsp;&nbsp;

"NU0713",&nbsp;&nbsp;&nbsp;

"NU0922",

"NU0364",&nbsp;&nbsp;&nbsp;

"NX0609",&nbsp;&nbsp;&nbsp;

"NX0610"};

脚本编写回复：使用两个时间点创建分类变量

这是我对您似乎有效的代码的返工

New Column( "myJOBCODE Status", Character, Nominal ) << Formula(
 If( Row() == 1,
  mylist = {"HH0029", "HH0030", "HH0241", "HH0242", "HH0317", "HH0635", "HH0635", "HH0636", "HH0636", "HH0639", "HH0742",
  "HH0750", "HX0002", "HX0003", "HX0008", "HX0010", "HX0022", "HX0106", "HX0106", "HX0107", "HX0114", "HX0115", "SH0049",
  "SH0504", "SH0678", "HH0113", "HH0708", "HH0746", "HX0111", "NU0017", "NU0100", "NU0200", "NU0203", "NU0206", "NU0207",
  "NU0213", "NU0243", "NU0244", "NU0300", "NU0301", "NU0305", "NU0327", "NU0328", "NU0362", "NU0364", "NU0400", "NU0422",
  "NU0423", "NU0424", "NU0425", "NU0440", "NU0461", "NU0615", "NU0618", "NU0619", "NU0620", "NU0621", "NU0622", "NU0625",
  "NU0800", "NU0801", "NU0923", "NX0002", "NX0006", "NX0017", "NX0018", "NX0019", "NX0023", "NX0125", "NX0465", "NX0466",
  "NX0609", "NX0610", "NU0610", "NU0700", "NU0710", "NU0713", "NU0922", "NU0364", "NX0609", "NX0610"}
 );
 isThere = Function( {value},
  {},
  If( Contains( mylist, value ),
   1,
   0
  )
 );
 a = :JOBCODE Timepoint1;
 b = :JOBCODE Timepoint2;
 If(
  isThere( a ) & b == "", "Termination/Separation",
  a == "" & isThere( b ), "New Employee",
  isThere( a ) & isThere( b ), "No Change"
 );
);

回复：使用两个时间点创建分类变量非常感谢您的帮助！您的代码不仅可以达到我的预期，而且您的版本也比我的版本高效。做得好，先生！