The IMPORT WIZARD in the ADX INTERFACE may encounter problems


The ADX Interface allows variable names up to length 8. Hence when you use the ADX Import wizard, the SAS global option VALIDVARNAME=V6 is set to restrict the variable name to 8 characters. This may cause a problem if your variables are longer than 8 characters and have the same first 8 characters in that the ADX Interface will report in the SAS LOG

WARNING: Variable XYZ already exists on file libname.dataset.

Furthermore, the ADX IMPORT WIZARD will allow the factor levels to be longer than 16 characters in length. However, if you select the OPTIMIZE button to optimize the response using the Prediction Profiler, Contour Optimizer, Contour Plot, Surface Plot or Numerical Optimzer, the ADX Interface will abend if there are variables with factor levels longer than 16 characters in length used in the optimization.

To circumvent the abend, define your factor levels with 16 or less characters.