topic Re: SAS Table Error - How to Solve? in SAS Programming

SAS Table Error - How to Solve?

jgrl55 — Mon, 18 Nov 2019 05:06:54 GMT

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.

Re: SAS Table Error - How to Solve?

SASKiwi — Mon, 18 Nov 2019 05:31:49 GMT

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.

Re: SAS Table Error - How to Solve?

jgrl55 — Mon, 18 Nov 2019 06:05:45 GMT

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