Sas Ondemand EM

[Saszealot]

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.

[DougWielenga · Accepted solution]

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