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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.