topic Re: how to do sum group wise analysis and insert after the group by using loops or arrays in SAS Programming

how to do sum group wise analysis and insert after the group by using loops or arrays

thanikondharish — Sun, 14 Mar 2021 10:52:13 GMT

I have sashelp.class data set like above dataset and how to do group wise analysis in datastep block?

first output:

how to sex wise sum and insert extra record group wise in dataset(we should do data step block only)

for ref:

Re: how to do sum group wise analysis and insert after the group by using loops or arrays

ballardw — Sun, 14 Mar 2021 11:27:03 GMT

Why?

Including such summary data in a data set means that you can't use it for almost any purpose except printing. And Proc Report will do that.

or Proc Summary and looking at the proper _type_ values.

proc summary data=sashelp.class;
   class sex name;
   var age height weight;
   types name*sex sex;
   output out=work.summary (drop=_freq_) sum=;
run;

proc sort data=work.summary 
    out=work.want (drop=_type_);
   by sex descending _type_ name;
run;

Re: how to do sum group wise analysis and insert after the group by using loops or arrays

Ksharp — Sun, 14 Mar 2021 11:41:52 GMT

data have;
set sashelp.class;
run;

proc report data=have nowd out=x;
column name sex _sex  age height weight;
define name/display;
define sex/order noprint;
define _sex/computed 'sex';
define age/analysis sum;
define height/analysis sum;
define weight/analysis sum;
compute before sex;
 temp=sex;
endcomp;
compute _sex/character length=20;
 _sex=temp;
endcomp;
compute after sex;
_sex=cats(sex,'-total');
endcomp;
break after sex/summarize;
run;

Re: how to do sum group wise analysis and insert after the group by using loops or arrays

thanikondharish — Sun, 14 Mar 2021 11:57:45 GMT

How to do in datastep block

Re: how to do sum group wise analysis and insert after the group by using loops or arrays

Ksharp — Sun, 14 Mar 2021 12:14:27 GMT

proc sort data=sashelp.class out=have;
by sex;
run;

data want;
length name sex $ 20;
call missing(_age,_height,_weight);
 do until(last.sex);
   set have;
   by sex;
   _age+age;_weight+weight;_height+height;
   output;
 end;
call missing(name,age,weight,height);
sex=cats(sex,'-total');
age=_age;weight=_weight;height=_height;
output;
drop _:;
run;

Re: how to do sum group wise analysis and insert after the group by using loops or arrays

Kurt_Bremser — Sun, 14 Mar 2021 12:19:27 GMT

Maxim 14. Don't be stupid and try to reinvent the wheel.

@thanikondharish wrote:
How to do in datastep block

Re: how to do sum group wise analysis and insert after the group by using loops or arrays

mkeintz — Mon, 15 Mar 2021 03:11:11 GMT

Let SAS sequence your data via the power of where:

data want (drop=_:);
  set sashelp.class (where=(sex='F'))
      sashelp.class (where=(sex='M'));
  by sex;
  _age+age;
  _height+height;
  _weight+weight;
  output;
  if last.sex;
  age=_age;
  height=_height;
  weight=_weight;
  name='Total';
  output;
  call missing(of _:);
run;