Displaying only subtotal and total in proc report

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 87
Accepted Solution

Displaying only subtotal and total in proc report

Hi,

i want to display only subtotal and total of given dataset using proc report

and supress the display of columns


Accepted Solutions
Solution
‎07-11-2012 09:14 AM
Super User
Super User
Posts: 7,079

Re: Displaying only subtotal and total in proc report

How about something like this?

proc report nofs headline data=sashelp.class;

  column sex height weight;

  define sex / group;

  define height / sum;

  define weight / sum;

  rbreak after / summarize;

run;

  S

  e

  x     Height     Weight

  -----------------------

  F      545.3        811

  M      639.1     1089.5

        1184.4     1900.5

View solution in original post


All Replies
Solution
‎07-11-2012 09:14 AM
Super User
Super User
Posts: 7,079

Re: Displaying only subtotal and total in proc report

How about something like this?

proc report nofs headline data=sashelp.class;

  column sex height weight;

  define sex / group;

  define height / sum;

  define weight / sum;

  rbreak after / summarize;

run;

  S

  e

  x     Height     Weight

  -----------------------

  F      545.3        811

  M      639.1     1089.5

        1184.4     1900.5

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 176 views
  • 0 likes
  • 2 in conversation