merging booleans into one row

[Krodde]

Hi,

I have a data set which contains  product_id's and a number of booleans where each row has  a boolean set to true.

I have multiple rows with the same product_id and each row has different booleans set to true

is there a way to group these rows in to one row per product_id?

example 

prod_ID    bool1    bool2      bool3   bool4

A               0           0            1           0

A               0           0            0           1

B               1           0            0           0

B               0           0            0           1

I would like to get a date set which looks like

A              0            0             1           1

B              1            0             0           1

Thanks

[Kurt_Bremser · Accepted solution]

Easily done with proc summary:

data have;
input prod_ID $   bool1    bool2      bool3   bool4;
datalines;
A               0           0            1           0
A               0           0            0           1
B               1           0            0           0
B               0           0            0           1
;

proc summary data=have;
by prod_id;
var bool:;
output out=want (drop=_freq_ _type_) max()=;
run;