topic Re: Proc freq SPARSE option in a 3-way table in SAS Programming

Proc freq SPARSE option in a 3-way table

Schwa — Thu, 23 Jan 2020 18:28:22 GMT

I’d like to be able to generate a 3-way frequency table using something like the SPARSE option for PROC FREQ, but only for the last variable present (i.e. I don’t want all possible values for the second variable to also show up for each value of the first variable.)

Is there a way to do this using SPARSE and PROC FREQ, or do I need to do this another way?

Re: Proc freq SPARSE option in a 3-way table

Schwa — Thu, 23 Jan 2020 18:30:25 GMT

To clarify: I want counts (including zero counts) for each distinct value of the third variable, but only for combinations of the first two variables that are already present in my data set.

Re: Proc freq SPARSE option in a 3-way table

Reeza — Thu, 23 Jan 2020 18:36:10 GMT

SPARSE will not handle that, you need another way. CLASSDATA is one option or using PROC TABULATE with a format and PRELOADFMT is a good option as well.