total denominator

pacman94 — Tue, 16 Feb 2021 15:17:38 GMT

I have the following dataset

ID	Yes_no	Group_1	Group_2
13	1	1	2
212	0	2	1
212	1	2	3
412	1	0	3
534	0	3	1

What I would like to add total_participants in the last column that needs to be static. For example, there are 5 records but only 4 unique ID so I need total_participants = 4. Something like this below:

ID	Yes_no	Group_1	Group_2	total_participants
13	1	1	2	4
212	0	2	1	4
212	1	2	3	4
412	1	0	3	4
534	0	3	1	4

I have no idea how to do this

I tried data want; set have;

total_participants = count(ID);

run;

Re: total denominator

maguiremq — Tue, 16 Feb 2021 15:38:42 GMT

This is a PROC SQL solution that avoids the warning telling you that it requires remerging summary statistics:

proc sql;
	select
				id,
				yes_no,
				group_1,
				group_2,
				(	select
								count(distinct id) as id_count
					from
								have	) as total_participants
	from
				have;
quit;

topic Re: total denominator in SAS Programming

total denominator

Re: total denominator