INVALID COLUMN NAMES IN ENTERPRISE MINER

[TgNoradilah]

Hi,

i tried to use exported SAS data set from SAS EG in my EM project. However, data source wizard give a server error pop up mentioning that "The data set contains variables with invalid column names. The SAS option VALIDVARNAME=ANY is currently disabled. Please consult your SAS Language Reference for more information."

I had rename my variable so that the variable follow the rules of SAS Variable name and re-export my data. But I still get the same message. What should I do?

[Kurt_Bremser · Accepted solution]

Run a PROC CONTENTS on the dataset in question, and post the results here. Also make absolutely sure that EM sees the new, corrected dataset.

[TgNoradilah]

I run PROC CONTENTS again as you suggest and seems like there is one more variable that have special case "-" in the variable name. 

Your suggestions makes my eyes more alert. 

[Kurt_Bremser]

Just a practical application of Maxim 3 😉