I am trying to cluster a datset based on several nominal inputs and one interval level input. I'm getting the error of the max target levels of 512 being exceeded - and I think it may be because SAS is reading the interval input as nominal data. When I try to change this under the File Import Node (Train - Variables), the option to change this variable to the nominal level is greyed out.
Does anyone know how I can change the variable nominal to interval ?
Strange, it's usually the other way around. By default (with the Basic Advisor), any numeric variable should be set to Interval. If you use the Advanced Advisor, then if the number of levels for a numeric variable is less than 20 (by default), then it is set as Nominal, so not sure how a variable with that many levels is being set as Nominal (unless it is being read in as character instead of numeric).
If nothing else, you can use a Metadata node (from Utility tab) to change the level of the variable that you want to be interval.
Strange, it's usually the other way around. By default (with the Basic Advisor), any numeric variable should be set to Interval. If you use the Advanced Advisor, then if the number of levels for a numeric variable is less than 20 (by default), then it is set as Nominal, so not sure how a variable with that many levels is being set as Nominal (unless it is being read in as character instead of numeric).
If nothing else, you can use a Metadata node (from Utility tab) to change the level of the variable that you want to be interval.
Thanks for your input. It seemed to work when I changed the file format from xlsx to a csv.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.