Proc report is likely not the tool to create the second table.
The reason is that the way Proc Report builds tables that the summaries will not create subgroup totals the way you show them.
You can get the summaries you want but you will have to do a little work.
Please examine this code and the output data set:
proc summary data=sashelp.class;
class sex age;
var height weight;
output out=work.classsum mean=;
run;
There is a variable in the output data set work.classsum named _TYPE_ that SAS provides to indicate which summary a line comes from. _Type_=0 is an overall summary, _type_=1 is the summary for AGE only, _type_=2 is the summary for Sex only, and _type_=3 indicates the summary for the combinations of Sex and Age variable groups.
If I wanted to display the Age only group above the Sex and Age, which is very similar to what your table 2 does, I could use the _type_ variable to filter the records.
proc print data=work.classsum noobs;
where _type_ in (1,3);
var sex age height weight;
run;
With more class variables you get different summaries to consider, select and print.
A side effect of this, if you can make table 2 the exact same code removing one value of _type_ with create table one. Your statistic would be sum instead of the mean I used above.
