topic count by patient ID where N=4 in SAS Software for Learning Community

count by patient ID where N=4

centro_9 — Fri, 07 Oct 2022 13:45:04 GMT

Hi I need to count in the data by patient ID where N=4

patientID	fREQ	STAT	FLAG
1	4	N	4
1	4	MIN	1
1	4	MAX	1
1	4	MEAN	1
2	12	N	12
2	12	MIN	1
2	12	MAX	1
2	12	MEAN	1
3	4	N	4
3	4	MIN	1
3	4	MAX	1
3	4	MEAN	1

count where

centro_9 — Fri, 07 Oct 2022 13:45:49 GMT

i I need to count in the data by patient ID where N=4

patientID	fREQ	STAT	FLAG
1	4	N	4
1	4	MIN	1
1	4	MAX	1
1	4	MEAN	1
2	12	N	12
2	12	MIN	1
2	12	MAX	1
2	12	MEAN	1
3	4	N	4
3	4	MIN	1
3	4	MAX	1
3	4	MEAN	1

Re: count where

HB — Fri, 07 Oct 2022 15:06:46 GMT

You've posted what looks like a dataset of the output of a SAS procedure.

How about posting some actual sample data? Are you simply wanting to select the items in a given data set that are in it 4 times?

proc sql;
select patientid, count(patientid)
from have
group by patientid
having count(patientid) = 4;
run;

Re: count by patient ID where N=4

Tom — Fri, 07 Oct 2022 14:52:36 GMT

Assuming you want the count of the number of patient ids where the value of N is 4.

proc sql;
  select count(*) from have
  where stat='N' and flag=4
  ;
quit;

Re: count by patient ID where N=4

Reeza — Fri, 07 Oct 2022 15:28:01 GMT

Go back to your proc means step and use the ODS OUTPUT instead of the OUT data set, it's a cleaner format.

proc means data=sashelp.class nway stackods N MEAN MIN MAX ;
class sex;
var age;
ods output summary=want;
run;

proc print data=want;
run;

@centro_9 wrote:

Hi I need to count in the data by patient ID where N=4

patientID

fREQ

STAT

FLAG

1

4

N

4

1

4

MIN

1

1

4

MAX

1

1

4

MEAN

1

2

12

N

12

2

12

MIN

1

2

12

MAX

1

2

12

MEAN

1

3

4

N

4

3

4

MIN

1

3

4

MAX

1

3

4

MEAN

1

Re: count by patient ID where N=4

Reeza — Fri, 07 Oct 2022 15:28:19 GMT

Please do not post the same question multiple times.