I have data something like this:
SampleID 1result 2result 3result
A 0.9 0.4 1.2
B 0.3 0.6 0.8
C 0.2 0.7 2.3
Which are in excel. I am very familiar with using the libname statement method to bring an excel file into SAS. BUT, as you can see the column names have leading numbers. Which SAS replaces with an _ at the time of import. This is problematic because I then lose the only identifying piece of information about that column. If SAS were to put a leading underscore in FRONT of the number, and not replace the number, that would be fine.
These data are coming directly from a laboratory instrument, and I am assured by the tecnicians that the column headings cannot be changed.
So, besides editing every excel file prior to import, is there a way to bring in the data from excel and not lose the useful column information? There are many, many of these excel files.......
Thank you,
NWV