270312_zh-TW

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"
 );
);

回复：使用兩個時間點創建分類變量非常感謝您的幫助！您的代碼不僅可以達到我的預期，而且您的版本也比我的版本高效。做得好，先生！