BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
pvareschi
Quartz | Level 8

Would it be possible to clarify the meaning of values "Computed" and "User-Specified" for the above property?

The example at page 2-61 of the Course Notes of "Applied Analytics Using SAS Enterprise Miner" sets the property to "Missing"; however, what if more than one variable is replaced, possibly with different replaced values (missing and non-missing)? Should "User-Specified" be used instead? In what scenarios should "Computed" be used?

1 ACCEPTED SOLUTION

Accepted Solutions
gcjfernandez
SAS Employee

Meaning of "Computed": This is the default setting for the replacement value. By default the replacement node identify outliers (mean +- 3 SD) for interval inputs and compute this truncated values (Top ceiling) and replaces globally for all inputs. If you want to apply this option only for the selected input variable then you need to click the replacement editor and apply the required setting there.

Instead of using this computed value (Mean +- 3sd) you could also use a user-specified constant value in the global setting or in the replacement editor individually for the selected inputs.
Similarly you can also choose 'Missing'.

In the course demo, we want to replace all zeros only in DemMedIncome variable. Therefore using the replacement editor we selected DemMedianincome and  specified 1 as the lower replacement value to identify all the records with 0 income  and replaced with missing.

I hope this explanation is clear. If you need further clarification please let me know. Also adding a screenshot of the replacement editor window.

gcjfernandez_gmail_com_0-1589052316842.png

 

View solution in original post

1 REPLY 1
gcjfernandez
SAS Employee

Meaning of "Computed": This is the default setting for the replacement value. By default the replacement node identify outliers (mean +- 3 SD) for interval inputs and compute this truncated values (Top ceiling) and replaces globally for all inputs. If you want to apply this option only for the selected input variable then you need to click the replacement editor and apply the required setting there.

Instead of using this computed value (Mean +- 3sd) you could also use a user-specified constant value in the global setting or in the replacement editor individually for the selected inputs.
Similarly you can also choose 'Missing'.

In the course demo, we want to replace all zeros only in DemMedIncome variable. Therefore using the replacement editor we selected DemMedianincome and  specified 1 as the lower replacement value to identify all the records with 0 income  and replaced with missing.

I hope this explanation is clear. If you need further clarification please let me know. Also adding a screenshot of the replacement editor window.

gcjfernandez_gmail_com_0-1589052316842.png