merging booleans into one row

Krodde — Fri, 24 Apr 2020 09:41:14 GMT

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

Re: merging booleans into one row

Kurt_Bremser — Fri, 24 Apr 2020 09:46:47 GMT

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;

topic merging booleans into one row in New SAS User

merging booleans into one row

Re: merging booleans into one row