Generating a data set that includes zero counts

EmilyAV — Fri, 15 Oct 2021 18:47:09 GMT

I have a dataset organized as follows:

data have;

infile id group1 $ group2 $;

datalines

1 a1 b1

2 a1 b2

3 a2 b1

;

run;

Group1 contains 50 categories with no missing values.

Group2 contains 2 categories and some missing values.

I need to generate a dataset that includes counts for all combinations of group 1 and group 2, including an observation of 0 when group 2 has a missing value.

I've been using proc freq as follows:

proc freq data=have;
tables group1*group2 / crosslist missing out=want;
run;

This code displays the results that I'm looking for, but the generated dataset does not include observations where group1*group2 counts are missing. The result is not changed by using the missprint option. Is there another approach I might try?

Thank you.

Re: Generating a data set that includes zero counts

PaigeMiller — Fri, 15 Oct 2021 18:58:46 GMT

Use the SPARSE option in the TABLES statement of PROC FREQ

Re: Generating a data set that includes zero counts

EmilyAV — Fri, 15 Oct 2021 19:26:29 GMT

Thank you!

topic Re: Generating a data set that includes zero counts in New SAS User

Generating a data set that includes zero counts

Re: Generating a data set that includes zero counts

Re: Generating a data set that includes zero counts