topic Sum rows by group and concatenate in New SAS User

Sum rows by group and concatenate

dapenDaniel — Mon, 24 Feb 2020 21:04:06 GMT

Hi,

I have a dataset as below.

data have;
input name $ Var1 Var2 Var3 Var4;
datalines;
AA 0 0 0 1 
AA 0 1 0 0
BB 0 0 1 0 
BB 1 0 0 0
run;

I want the dataset as below.

ID Var_Con

AA 0101

BB 1010

what program do I need to use? Thanks.

Re: Sum rows by group and concatenate

novinosrin — Mon, 24 Feb 2020 21:12:57 GMT

data have;
input name $ Var1 Var2 Var3 Var4;
datalines;
AA 0 0 0 1 
AA 0 1 0 0
BB 0 0 1 0 
BB 1 0 0 0
;
run;
proc summary data=have nway;
class name;
var var1-var4;
output out=temp(drop=_:) sum=;
run;

data want;
 set temp;
 length var_con $4;
 var_con=cats(of var1-var4);
 keep name var_con;
run;

Re: Sum rows by group and concatenate

yabwon — Mon, 24 Feb 2020 21:22:40 GMT

Maybe like this:

data have;
input name $ Var1 Var2 Var3 Var4;
datalines;
AA 0 0 0 1 
AA 0 1 0 0
BB 0 0 1 0 
BB 1 0 0 0
;
run;

data want;
  set have;
  by name;
  array A Var:;
  array B[4] _temporary_;

  do over A;
    B{_i_} + A;
  end;

  if last.name then
    do;
      var_con = cats(of B[*]);  
      output;
      call missing(of B[*]);
    end;
    keep name var_con;
run;

All the best

Bart