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

Using the Data source Wizard,getting to step 4 of step 8 metadata advisor options,then choosing advanced-customize, advanced advisor options.Class level count threshold does not allow me to change the default  value of 20 to 2. What can I do? using the basic options takes time.

1 ACCEPTED SOLUTION

Accepted Solutions
DougWielenga
SAS Employee

The property you are describing has the following definition:

Class Levels Count Threshold

If "Detect class levels"=Yes, interval variables with less than the number specified for this property will be marked as NOMINAL. The default value is 20.

 

First make sure that "Detect class levels"=Yes assuming you want to have SAS Enterprise Miner detect the levels at all.  Having said that, if you change the Class Levels Count Threshold from 20 to 2, you are effectively saying that any variable with a value less than 2 levels will be marked as NOMINAL.   Please note variables that the only possible value less than 2 is 1 (assuming the variable is not completely missing) and a variable with only one level will have Level=UNARY and  Role=REJECTED.  A variable with 2 levels will be coded with Level=BINARY and Role=Input.  Even if you set the cutoff at 3, no variables will be defined as NOMINAL.   If you change the minimum value to 4, a variable with 3 levels would be marked as NOMINAL.   

 

Even if you leave the default values when using the Advanced Advisor while running the wizard, it is trivial to sort by the Role column in Step 5 by simply clicking on the column heading.  You can then highlight all of the NOMINAL variables and change them to INTERVAL where possible (e.g. as long as they are not coded as character values in the Input Data Source).   

 

I hope this helps!

Doug 



View solution in original post

1 REPLY 1
DougWielenga
SAS Employee

The property you are describing has the following definition:

Class Levels Count Threshold

If "Detect class levels"=Yes, interval variables with less than the number specified for this property will be marked as NOMINAL. The default value is 20.

 

First make sure that "Detect class levels"=Yes assuming you want to have SAS Enterprise Miner detect the levels at all.  Having said that, if you change the Class Levels Count Threshold from 20 to 2, you are effectively saying that any variable with a value less than 2 levels will be marked as NOMINAL.   Please note variables that the only possible value less than 2 is 1 (assuming the variable is not completely missing) and a variable with only one level will have Level=UNARY and  Role=REJECTED.  A variable with 2 levels will be coded with Level=BINARY and Role=Input.  Even if you set the cutoff at 3, no variables will be defined as NOMINAL.   If you change the minimum value to 4, a variable with 3 levels would be marked as NOMINAL.   

 

Even if you leave the default values when using the Advanced Advisor while running the wizard, it is trivial to sort by the Role column in Step 5 by simply clicking on the column heading.  You can then highlight all of the NOMINAL variables and change them to INTERVAL where possible (e.g. as long as they are not coded as character values in the Input Data Source).   

 

I hope this helps!

Doug 



sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

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