Changing Variable Inputs to Interval on File Import Node - Enterprise Miner

[dlansdowne0090]

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 ? 

[WendyCzika · Accepted solution]

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.

[dlansdowne0090]

Thanks for your input. It seemed to work when I changed the file format from xlsx to a csv.