The SAS Output Delivery System and reporting techniques

PROC Tabulate, PC SAS vs. Mainframe SAS

Reply
N/A
Posts: 0

PROC Tabulate, PC SAS vs. Mainframe SAS

I'm trying to convert a PC SAS program to the mainframe. Is it possible in mainframe SAS to suppress the labels for CLASS variables? It seems the labels are automatically suppressed in PC SAS. Any advice would be greatly appreciated. Thanks.
SAS Employee
Posts: 174

Re: PROC Tabulate, PC SAS vs. Mainframe SAS

Posted in reply to deleted_user
TABULATE is supposed to behave the same regardless of the hardware platform and operating system.

To suppress class headings, assign an empty label, e.g.:
[pre]
proc tabulate data=sashelp.class;
class sex age;
var height;
table sex, age=""*height*(mean median);
run;
[/pre]
Things get a little trickier with row headings. By default TABULATE will render an empty heading cell rather than tossing the cell. If you want to toss the cell, use the ROW=FLOAT TABLE statement option, e.g:
[pre]
proc tabulate data=sashelp.class;
class sex age;
var height;
table sex="", age=""*height*(mean median)/row=float;
run;
[/pre]

-- David Kelley, SAS
N/A
Posts: 0

Re: PROC Tabulate, PC SAS vs. Mainframe SAS

Posted in reply to deleted_user
Thanks a lot David. Your first recommendation was exactly what I was trying to do and it worked like a champ!
Ask a Question
Discussion stats
  • 2 replies
  • 163 views
  • 0 likes
  • 2 in conversation