topic INVALID COLUMN NAMES IN ENTERPRISE MINER in New SAS User

INVALID COLUMN NAMES IN ENTERPRISE MINER

TgNoradilah — Wed, 05 Feb 2020 08:33:17 GMT

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?

Re: INVALID COLUMN NAMES IN ENTERPRISE MINER

Kurt_Bremser — Wed, 05 Feb 2020 08:51:21 GMT

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.

Re: INVALID COLUMN NAMES IN ENTERPRISE MINER

TgNoradilah — Wed, 05 Feb 2020 09:08:55 GMT

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.

Re: INVALID COLUMN NAMES IN ENTERPRISE MINER

Kurt_Bremser — Wed, 05 Feb 2020 09:19:36 GMT

Just a practical application of Maxim 3 😉