I have the the following question:
is there any possibility to write the SAS data into MS Excel named range without writing the variable names? (I have found the libname option HEADER=NO that for reading without varnames, but this doesn't work when writing into excel).
If you want to write into an existing range name (in an existing excel workbook), you have very few methods where the range does not have a header row.
It is possible that the only way will be the (much-deprecated) DDE which has worked in all releases of SAS on windows since SAS version 6.08. It needs to be able to write into an open instance of excel.
Which versions of excel and sas do you use?