topic count and denominator in SAS Programming

count and denominator

radhikaa4 — Fri, 13 Dec 2019 14:35:38 GMT

I would like to create a dataset that i want to use as a treatment group as denominator for calculated field after

For example:

patientid	group
1234	placebo
4564	placebo
5646	treatment
6544	placebo
2345	treatment
2343	placebo

I want to do something like:

group	count
placebo	4
treatment	2

I want count for placebo and treatment as a stored variable so that it is updated automatically when I use Placebo total denominator as 4 and treatment denominator as 2 for all proc freq calculations

I tried

proc sql;

create table group_denominator as

select group, count(*) as count

from test;

quit;

but it doesn't do what i would like it to

Thanks

Re: count and denominator

novinosrin — Fri, 13 Dec 2019 14:38:57 GMT

proc sql;

create table group_denominator as

select group, count(*) as count

from test
group by group;

quit;

Re: count and denominator

PaigeMiller — Fri, 13 Dec 2019 14:39:01 GMT

proc freq data=have;
    table group;
run;

Re: count and denominator

ed_sas_member — Sat, 14 Dec 2019 09:42:57 GMT

Hi @radhikaa4

You can try either:

proc sql;
	create table group_denominator as
	select group, count(*) as count
	from test
	group by group;
quit;

proc freq data=test noprint;
    table group / out=group_denominator (drop=percent);
run;

In PROC SQL, the GROUP BY clause enables to compute summary statistics (in your case: n) for each modality of the specified variable (in your case: group).

Best,