Proc Print Query

[scb]

The below code is fine.  May I know how to get rid of the "final total" - 12846292 and also the second MAKE name in the subtotal.  Any idea? Thanks.

The below code generated:

Volvo     .....................

              ....................

              .....................

Volvo                         $410,594

                                  12846292

I would to have:

Volvo     .....................

              ....................

              .....................

                                   $410,594

data cars;
set sashelp.cars;
run;

proc print data=cars;
by make;
id make;
sum Invoice;
run;

[ballardw]

When you start wanting more control over the selection of variables you may need to move to another procedure such as Proc Report that allows different types of summaries appearing.

[Ksharp]

data cars;
set sashelp.cars;
run;
options nobyline;
proc report data=cars nowd spanrows;
by make;
define make/group;
define invoice/analysis sum;
define MSRP	/display;
define EngineSize/display;	
define Cylinders/display;
define Horsepower/display;
define MPG_City/display;
define MPG_Highway/display;
define Weight/display;
define Wheelbase/display;
define Length/display; 
break after make/summarize;
run;