Replacement Node won't let me change a number to a string: the variable is Nominal

Mike90 — Mon, 13 Nov 2017 18:25:10 GMT

The target is a set of integers (representing days).

I added a Metadata node to change the target to be Nominal.

I added a Replacement Node after the Metadata Node, and ran it to update the path.

I open the Replacement Editor (Replacement Node: Class Variable : Replacement Editor : ...).

It lists all the integer values that occur for the target, and in the next Column there are N's for type (Nominal).

I can change the values to numbers, but if I use one or more characters it clears the entry when I press return.

I changed the target to Nominal in the Data Source, and deleted the Metadata node.

I still can't change the number to one or more characters in the Replacement Node.

What I am trying to do is manually put the numbers into 4 groups (that have a meaningful name, not a number).

Thanks.

Re: Replacement Node won't let me change a number to a string: the variable is Nominal

WendyCzika — Fri, 17 Nov 2017 13:40:09 GMT

I think it's because even though that variable is now nominal, it is still a numeric variable, so can't have character values in it. You might need to use a SAS Code node to create a new variable that groups the numbers into groupings named how you want. The Interactive Binning node (using the Interactive Binning editor) will allow you to group the values how you want, but there you can't control the names of the groups.

topic Replacement Node won't let me change a number to a string: the variable is Nominal in SAS Data Science

Replacement Node won't let me change a number to a string: the variable is Nominal

Re: Replacement Node won't let me change a number to a string: the variable is Nominal