The solution you provided works fine when there is one variable to be reported but when there are 2+ vars it won't work...because one can't make the distinction between one variable and another if the name is blanked.
The thing is that I must have both variables stats to be reported in the same table.
Is there a way to keep the var name but at the same time make the first var modality not being a merged cell when routed via ODS to Excel.
We get that request often. We could consider adding an option to the ExcelXP tagset that would turn a single row of row-spanning data cells into two rows. The first row would have all empty data cells, and the second row would have the PROC-generated values.
I will run this suggestion past the ExcelXP tagset developer.
One possible workaround is to make a category variable that contains the value and the variable name, that forces the variable name (Q01a or Q01b) in each cell -- which still may not be optimal, but will allow you to get rid of the "double wide" cell.