In SAS^® Enterprise Miner™, the Partial Least Squares (PLS) node should automatically set the exported data Role to Rejected for variables that are rejected by the model. However, the node might not set the Role to Rejected. As a result, subsequent nodes do not reject the correct variables.

The problem occurs when you run SAS Enterprise Miner using a non-English locale.

There are no errors or warnings to indicate a problem.

Workarounds include either of these two choices. Choose depending on whether you prefer an automatic method or a manual method:

• Use a Metadata node to manually change the Role to Rejected for variables that should be rejected in subsequent nodes. Follow these steps:
  1. Run the Partial Least Squares node. View the results.
  2. In the Results window, select View ► Variable Selection ► Variable Selection.
  3. View the Role column in the Variable Selection table. Note which variables are rejected. Close the Results window.
  4. Connect a Metadata node after the Partial Least Squares node.
  5. Click ... to open the Variables Train property. In the Variables window, change the New Role to Rejected for each of the variables that you noted in the previous step. Select OK to close the window.


• Use a SAS Code node to automatically change the Role to Rejected for variables that should be rejected in subsequent nodes. Follow these steps:
  1. Connect a SAS Code node after the Partial Least Squares node.
  2. Click ... to open the Code Editor property. In the Training Code window, enter this code:
     filename X "&EM_FILE_CDELTA_TRAIN"; data _rejvars; set &EM_LIB..&EM_METASOURCE_NODEID._varselout; where _ROLE_ = "%sysfunc(sasmsg(sashelp.dmine, rpt_pls_label_rejected, noquote))"; length varname $32; varname = upcase(trim(left(scan(Variable,1,'')))); run; proc sort data=_rejvars NODUPKEY; by varname; run; data _null_; length string $200; file X; set _rejvars; where _ROLE_ = "%sysfunc(sasmsg(sashelp.dmine, rpt_pls_label_rejected, noquote))"; string = "if upcase(trim(left(NAME))) eq '"!!trim(varname)!!"' then ROLE='REJECTED';"; put string; run; filename x; proc delete data=_rejvars; run;
     Close the window. Select Yes to save the changes.

With either workaround, subsequent nodes use the corrected Role for rejected variables.

Operating System and Release Information