topic Re: The data set contains variables with invalid column names. The SAS option VALIDVARNAME=ANY disab in SAS Software for Learning Community

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

HaribaskarS — Thu, 13 Jan 2022 21:00:22 GMT

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

Re: The data set contains variables with invalid column names. The SAS option VALIDVARNAME=ANY disab

PaigeMiller — Thu, 13 Jan 2022 21:10:51 GMT

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.

Re: The data set contains variables with invalid column names. The SAS option VALIDVARNAME=ANY disab

Reeza — Thu, 13 Jan 2022 21:24:00 GMT

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=....

Re: The data set contains variables with invalid column names. The SAS option VALIDVARNAME=ANY disab

HaribaskarS — Fri, 14 Jan 2022 12:07:45 GMT

Thanks for the quick reply. That worked