topic Re: Displaying only subtotal and total in proc report in SAS Programming https://communities.sas.com/t5/SAS-Programming/Displaying-only-subtotal-and-total-in-proc-report/m-p/104291#M258393 <HTML><HEAD></HEAD><BODY><P>How about something like this?</P><P>proc report nofs headline data=sashelp.class;</P><P>&nbsp; column sex height weight;</P><P>&nbsp; define sex / group;</P><P>&nbsp; define height / sum;</P><P>&nbsp; define weight / sum;</P><P>&nbsp; rbreak after / summarize;</P><P>run;</P><P></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; S</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; e</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp; Height&nbsp;&nbsp;&nbsp;&nbsp; Weight</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; -----------------------</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 545.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 811</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 639.1&nbsp;&nbsp;&nbsp;&nbsp; 1089.5</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1184.4&nbsp;&nbsp;&nbsp;&nbsp; 1900.5</SPAN></P></BODY></HTML> Wed, 11 Jul 2012 13:14:09 GMT Tom 2012-07-11T13:14:09Z Displaying only subtotal and total in proc report https://communities.sas.com/t5/SAS-Programming/Displaying-only-subtotal-and-total-in-proc-report/m-p/104290#M258392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i want to display only subtotal and total of given dataset using proc report</P><P>and supress the display of columns </P></BODY></HTML> Wed, 11 Jul 2012 10:52:39 GMT https://communities.sas.com/t5/SAS-Programming/Displaying-only-subtotal-and-total-in-proc-report/m-p/104290#M258392 santhosh 2012-07-11T10:52:39Z Re: Displaying only subtotal and total in proc report https://communities.sas.com/t5/SAS-Programming/Displaying-only-subtotal-and-total-in-proc-report/m-p/104291#M258393 <HTML><HEAD></HEAD><BODY><P>How about something like this?</P><P>proc report nofs headline data=sashelp.class;</P><P>&nbsp; column sex height weight;</P><P>&nbsp; define sex / group;</P><P>&nbsp; define height / sum;</P><P>&nbsp; define weight / sum;</P><P>&nbsp; rbreak after / summarize;</P><P>run;</P><P></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; S</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; e</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp; Height&nbsp;&nbsp;&nbsp;&nbsp; Weight</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; -----------------------</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 545.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 811</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 639.1&nbsp;&nbsp;&nbsp;&nbsp; 1089.5</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1184.4&nbsp;&nbsp;&nbsp;&nbsp; 1900.5</SPAN></P></BODY></HTML> Wed, 11 Jul 2012 13:14:09 GMT https://communities.sas.com/t5/SAS-Programming/Displaying-only-subtotal-and-total-in-proc-report/m-p/104291#M258393 Tom 2012-07-11T13:14:09Z