how can I get rid of total of sub-total in a multiple by variable

Nietzsche — Mon, 07 Nov 2022 04:44:38 GMT

Hi, just doing an example on pg 135 of the official specialist prep guide, after I run the code.

proc sort data=cert.usa out=temp2;
by manager jobtype;
run;

data budget2 (keep=manager jobtype payroll);
set temp2;
by manager jobtype;

if wagecat='S' then yearly=wagerate*12;
if wagecat='H' then yearly=wagerate*2000;
if first.jobtype then payroll=0;
payroll+yearly;
if last.jobtype;
run;


proc print data=budget2 noobs;
  by manager;
  var jobtype;
  sum payroll;
  where manager in ('Coxe', 'Delgado');
  format payroll dollar12.2;
run;

the result is this like. How can I get rid of the sum of sub-totals? I only want sub-total to show.

Re: how can I get rid of total of sub-total in a multiple by variable

PeterClemmensen — Mon, 07 Nov 2022 08:19:48 GMT

Unfortunately, this is not possible. You would have to use some other reporting procedure like Proc Report or Proc Tabulate.

topic Re: how can I get rid of total of sub-total in a multiple by variable in SAS Programming

how can I get rid of total of sub-total in a multiple by variable

Re: how can I get rid of total of sub-total in a multiple by variable