topic Re: calculating number of observations by day for multiple subjects in SAS Programming

calculating number of observations by day for multiple subjects

CMPSU — Thu, 09 Dec 2021 18:55:36 GMT

I have a large data set that I'd like to calculate number of "feeding events" by day for 120 individuals across 90 days.

There are anywhere from 90-200 feeding events per day.

Is there a way for SAS to "count" the number of times the EID shows up within the same date

Example:

EID TIME Consumed

840003208080904

08/22/2019

840003208080904

08/22/2019

840003208080904

08/22/2019

840003208080904

08/22/2019

120

840003208080905

08/22/2019

840003208080905

08/22/2019

840003208080905

08/22/2019

840003208080906

08/22/2019

840003208080906

08/22/2019

840003208080906

08/22/2019

Re: calculating number of observations by day for multiple subjects

ballardw — Thu, 09 Dec 2021 19:01:20 GMT

Count often brings proc Freq into play.

proc freq data=have;
   tables eid * time /list;
run;

is one way. If you want a data set you can add an out=datasetname to the option list after the / .

Several other procedures would work as well.

Re: calculating number of observations by day for multiple subjects

CMPSU — Fri, 10 Dec 2021 18:31:52 GMT

This worked! follow up question: How can a calculate average of # observations per day

EXAMPLE: 840003208080904 had and average of 34 recorded events /day across all 100 days