topic Grouping variables to create new variables SAS Enterprise Miner in SAS Data Science

Grouping variables to create new variables SAS Enterprise Miner

wave43 — Wed, 13 Jan 2016 16:27:30 GMT

What is the best way to group variables into a new variable (or replace existing one) in SAS Miner?

For example, the variable "color" has 4 values: Red, Green, Black, and White. I want to create a new variable "newcolor" which has values "No Color" for Black and White, and "Color" for Red and Green.

Thanks.

Re: Grouping variables to create new variables SAS Enterprise Miner

sbxkoenk — Thu, 14 Jan 2016 10:08:58 GMT

Hello,

What you want to do is creating a new variable by grouping levels (!) of a nominal variable.

In SAS Enterprise Miner, this can be done in multiple ways:

1. Replacement Node

2. Transform Variables node

3. entering code in the score code pane of the Code node

I would start with the Replacement node:

- Put the 'Default Limits Method' for interval variables on 'NONE'.

- Open the Replacement Editor for Class Variables.

- Enter replacement values in the only column you can edit.

The new variable will have the same name as the source variable but with an added prefix (I believe it's 'REP_' for the replacement node). The original source variable will get a 'rejected' role and the new derived variable will get an 'input' role (unless you are replacing the target variable, then the new variable will get the 'target' role).

Koen

Re: Grouping variables to create new variables SAS Enterprise Miner

wave43 — Thu, 14 Jan 2016 14:59:18 GMT

Thank you. The replacement node was straight forward. You saved me from reloading my data again.