Proc Tabulate Excel output: Variable name to the left of the categorical levels of the variable

[stayhydrated]

Hello, my question regarding proc tabulate is how to get the categorical variable name to appear to the left of the categorical levels of the variable, particularly in Excel output. 

The categorical variable name is Gender and the categorical levels are Male and Female.

For example, my current proc tabulate output in Excel looks like this (please ignore color scheme): 

I would like the output in Excel to look like this below (please ignore the color scheme):

Are there any options, statements etc. for proc tabulate to change to that kind of output? Are there ways to do this in ODS Excel? 

Please let me know if there's anything else I need to provide. 

Thanks in advance. 

[Ksharp]

1) Create a dummy variable which value is "Gender". like :
dummy="Gender" ;

2) use PROC REPORT instead .

[Ksharp · Accepted solution]

data have;
 set sashelp.class;
 dummy='Gender';
run;
proc tabulate data=have;
class dummy sex age;
table dummy=' '*sex=' ',age=' '*n=' ';
run;

[stayhydrated]

This is a very easy solution, thank you so much!

[ChrisNZ]

@Ksharp Your F and your M look really strange!  😉

[Ksharp]

Yeah. It is Chinese F and M. I am using sas in Chinese version .

[ChrisNZ]

@Ksharp Yes. I was being facetious 🙂

[Reeza]

PROC REPORT seems like the easiest solution. FYI - you can use the OUT option on PROC TABULATE to get the data/stats and then use PROC REPORT to display the summary stats and data as desired with more control.