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

 

 

This is a knowledge-sharing community for learners in the Academy. Find answers to your questions or post here for a reply.
To ensure your success, use these getting-started resources:

Estimating Your Study Time
Reserving Software Lab Time
Most Commonly Asked Questions
Troubleshooting Your SAS-Hadoop Training Environment

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 375 views
  • 0 likes
  • 2 in conversation