05-21-2014 04:57 AM
I use proc export in SAS EG (9.3 windows server side) to create a xls file.
The strange thing is if I use a sheet name that starts with a number, the first number is replaced with _.
Why is the first number replaced with a _.
PROC EXPORT DATA=work.test
05-21-2014 05:10 AM
There are several naming conventions within this game.
A sheetname can also be a SAS-table name. SAS table-names must start with a letter or an underscore.
Using that kind of information a table within SAS is a defined structure. That is messing in Excel, but you have range-names.
SAS/ACCESS(R) 9.3 Interface to PC Files: Reference