topic base sas in SAS Programming

base sas

rajeshalwayswel — Wed, 01 Nov 2017 04:30:49 GMT

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

Re: base sas

Norman21 — Wed, 01 Nov 2017 06:57:10 GMT

What code have you written?

Re: base sas

rajeshalwayswel — Wed, 01 Nov 2017 07:03:28 GMT

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

Re: base sas

Norman21 — Wed, 01 Nov 2017 07:36:04 GMT

What happens when you run this program?

Re: base sas

rajeshalwayswel — Wed, 01 Nov 2017 07:41:37 GMT

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

Re: base sas

Kurt_Bremser — Wed, 01 Nov 2017 07:59:18 GMT

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

Re: base sas

Astounding — Wed, 01 Nov 2017 08:12:52 GMT

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;

Re: base sas

rajeshalwayswel — Wed, 01 Nov 2017 08:15:03 GMT

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

Re: base sas

rajeshalwayswel — Wed, 01 Nov 2017 08:18:12 GMT

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