topic Re: Changing Variable Inputs to Interval on File Import Node - Enterprise Miner in SAS Data Science

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

dlansdowne0090 — Sun, 02 Apr 2017 18:19:07 GMT

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 ?

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

WendyCzika — Mon, 03 Apr 2017 17:11:37 GMT

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.

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

dlansdowne0090 — Tue, 04 Apr 2017 00:30:19 GMT

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