base sas

[rajeshalwayswel]

data have; usubjid col1 col2 col3; cards; 001 1 0 0 001 0 0 1 002 1 0 0 002 0 0 1 003 1 0 0 003 0 1 0 003 0 0 1 run; Required output: usubjid col1 col2 col3 001 1 0 1 002 1 0 1 003 1 1 1

[Norman21]

What code have you written?

[rajeshalwayswel]

data have;
input usubjid col1 col2 col3;
cards;
001 1 0 0
001 0 0 1
002 1 0 0
002 0 0 1
003 1 0 0
003 0 1 0
003 0 0 1
run;
Required output:
usubjid col1 col2 col3
001 1 0 1
002 1 0 1
003 1 1 1

[Norman21]

What happens when you run this program?

[rajeshalwayswel]

Required output for the above question is need only three observations from the seven observations...

[Kurt_Bremser]

Show the code you tried to get your result, and tell us the logical rule behind it.

[rajeshalwayswel]

for a subject to find the maximum count from each column...

[Astounding]

Here's one way to proceed:

proc summary data=have nway;

   var col1 col2 col3;

   class usubjid;

   output out=want (drop=_type_ _freq_) max=;

run;

[rajeshalwayswel]

great...I'm trying same in proc sql I'll send it...