topic Re: Count the number of people per year when they have multiple years in SAS in New SAS User

Count the number of people per year when they have multiple years in SAS

nab102 — Sat, 18 Jun 2022 13:04:24 GMT

Hi ,

I want to count the number of people who took a vaccine in a particular year when they have multiple years. This is what I have.

So if I want the number of people who took a vaccine in Year 2017, that's going to be 2, that is patient with Id L001 and L005. If a patient took two different vaccines in the same year (for eg. L002), we count it just once (I know that's obvious). This is what I want

Thank you

Re: Count the number of people per year when they have multiple years in SAS

sbxkoenk — Sat, 18 Jun 2022 13:42:54 GMT

Hello,

See here :

data work.have0;
input patient_id $ year_of_vaccine;
cards;
L001 2017
L001 2019 
L002 2020
L002 2020 
L003 2018
L003 2019
L004 2021
L005 2017
L006 2020
L006 2021
;
run;

proc sort data=work.have0 out=work.have1 NODUPKEY;
 by patient_id year_of_vaccine;
run;

PROC FREQ data=work.have1;
 tables year_of_vaccine / out=work.want;
run;
/* end of program */

Koen

Re: Count the number of people per year when they have multiple years in SAS

PGStats — Sat, 18 Jun 2022 18:07:47 GMT

To count only DISTINCT patients in a given year :

proc sql;
create table counts as
select 
    year_of_vaccine,
    count (distinct patient_id) as count
from have0
group by year_of_vaccine;
quit;

proc transpose data=counts out=want(drop=_name_);
var count;
id year_of_vaccine;
run;