I am trying to write code to create a SAS dataset from an Excel file. There are no variable Names in the Excel file. I want to be able to read in the Excel file and create the SAS file and have the system create Variable names, not use the first observation as the variable name.
I suggest you check in SAS help for the options associated with using LIBNAME for reading Excel spreadsheets. The documentation states that if you specify HEADER = NO then SAS will generate column names F1, F2 etc. instead of using the first row.
I looked up the HEADER=NO and read a SAS paper called "How to Excel with SAS".
This gave me the information on using the LIBNAME statement and Header=no. That worked great.
Still I have this question; is there a way when you have Excel open that you can use the SAS Addin tab (or SAS Solutions tab) and navigate to the file you have in excel and create a SAS dataset from it? My SAS Solutions tab only has the 'Log On' control enabled, but when I click it - it says "A problem has been encountered reading the .ini file".