topic Re: Proc Tabulate Excel output: Variable name to the left of the categorical levels of the variable in SAS Programming

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

stayhydrated — Tue, 01 Jun 2021 03:57:21 GMT

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.

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

Ksharp — Tue, 01 Jun 2021 12:04:12 GMT

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

2) use PROC REPORT instead .

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

Ksharp — Tue, 01 Jun 2021 12:07:54 GMT

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

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

Reeza — Tue, 01 Jun 2021 14:26:44 GMT

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.

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

stayhydrated — Tue, 01 Jun 2021 17:56:02 GMT

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

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

ChrisNZ — Wed, 02 Jun 2021 09:41:20 GMT

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

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

Ksharp — Wed, 02 Jun 2021 11:28:46 GMT

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

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

ChrisNZ — Wed, 02 Jun 2021 22:47:08 GMT

@Ksharp Yes. I was being facetious 🙂