The data set contains variables with invalid column names. The SAS option VALIDVARNAME=ANY disabled

[HaribaskarS]

Hi,

i tried to use exported SAS data set from SAS Studio 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. I have also ran the PROC CONTENTS for the dataset but I couldn't find any invalid column name. 

What should I do? 

EM ErrorPROC CONTENTS DATA

[PaigeMiller · Accepted solution]

By default, variable names cannot begin with a digit. The variable names you show are all illegal.

If you run this command

options validvarlist=any;

that should make your variable names acceptable to SAS.

[Reeza]

Or set VALIDVARNAME=V7 in SAS Studio and then export your data to be used in EM. I suspect this will be easier for OP to control than settings in EM.

options validvarname=v7;

proc export data=....

[HaribaskarS]

Thanks for the quick reply. That worked