calculating the variable based on grouping

Pooja98 — Mon, 25 Oct 2021 16:17:35 GMT

Hi Experts,

i came across the situation, where I'm not able to solve this?

For example,

date test result count of patient

04-11-20 Blood Positive 20

05-11-20 Urine Positive 56

04-11-20 Urine Negative 2

06-11-20 Urine Positive 7

05-11-20 Blood Negative 5

06-09-20 Blood Negative 52

My criteria is i need urine test only, to get the count of patient (both positive & negative)

like for urine test, total 65

please help me to resolve this situation. i have the data set of 20000 obs.

thanks in advance

Re: calculating the variable based on grouping

Reeza — Mon, 25 Oct 2021 16:25:36 GMT

This is the input data?

If so, assuming your data set name is HAVE and "count of patient" is PATIENT_COUNT.

proc freq data=HAVE;
where test="Urine";
table result / out=summary_urine;
weight patient_count;
run;

@Pooja98 wrote:

Hi Experts,

i came across the situation, where I'm not able to solve this?

For example,

date           test        result          count of patient

04-11-20   Blood     Positive        20

05-11-20   Urine     Positive        56

04-11-20   Urine     Negative       2

06-11-20   Urine     Positive         7

05-11-20   Blood     Negative 5

06-09-20   Blood    Negative       52

My criteria is i need urine test only, to get the count of patient (both positive & negative)

like for urine test, total 65

please help me to resolve this situation. i have the data set of 20000 obs.

thanks in advance

topic Re: calculating the variable based on grouping in New SAS User

calculating the variable based on grouping

Re: calculating the variable based on grouping