SAS Table Error - How to Solve?

[jgrl55]

Hi All - 

I've uploaded an excel file 10k rows to SAS Studio, which I'm trying to import into SAS Miner. When I go to Select a SAS Table, I receive the following error message: "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've been unsuccessful in searching/researching what this means and how to solve for it. Attached is a sample 50 lines of the CSV I'm trying to import. Yes, this is from Kaggle. 

[SASKiwi · Accepted solution]

The column headings in your spreadsheet do not follow SAS naming conventions. If you use the SAS option validvarname = any then this should fix the problem:

options VALIDVARNAME=ANY;

The alternative is to correct your column headings which must consist of only A-Z letters, 0 - 9 digits, or underscores.

[jgrl55]

Thanks for the quick reply! SAS Miner noob. Removing the spaces in the column headings worked.